Calculate Year over Year and Quarter over Quarter percent change
2
postgresql
Anonymous 2139
Anonymous 2139
5
If the table is guaranteed to have exactly one row for every quarter, you could try using the `LAG` analytic function to fetch a previous `spend_dollars` value:
Andriy M
PostgreSQL: Why does my foreach loop not work?
4
postgresql
Moshinoki
Moshinoki
5
`foreach` is a PL/pgSQL structure. You can not use it in a SQL statement.
Truilus
JSONB: text contains array value?
postgresql
Anonymous 1800
Anonymous 1800
3
The expression `attributes->>'owning_groups'`
Truilus
Postgresql 9.6 - Multiply the previous rows and answer in the next row
3
postgresql-9.6
greatman
greatman
Primary key to composite key without knowing constraint name
3
postgresql
Anonymous 1800
Anonymous 1800
6
If you want, you can rely on the automatic naming pattern Postgres uses. For primary keys, this is always table_name_pkey unless you specified a constraint name.
Truilus
Upgrading Postgres 12 to 13: pg_upgrade.exe fails
17
postgresql
Marc.2377
Marc.2377
6
The answer had to do with the option "*Beta: Use Unicode UTF-8 for worldwide language support*" being checked in my locale settings in Windows.
Marc.2377
Trigger code execution when exiting interactive psql client session
postgresql
PeterVandivier
PeterVandivier
Merging/combining values doesn't work as expected
11
postgresql-11
kha
kha
2
> The merging is also not allowed […] there is a significant gap in id numbers/non-adjacent ids (e.g 7, 12) (see expected output of grp 19 below).
Jack Douglas
PostgresSQL 10: JSONB update value of complex key/value structure
1
postgresql-10
Anonymous 1800
Anonymous 1800
5
As a forewarning: if you find yourself needing to do this, it means the data probably wants to be normalised. Answered more fully in...
PeterVandivier
How do I automate the import of CSV files into a PostgreSQL db at a specific time (each day)?
6
postgresql-11
kha
kha
7
Put your COPY command into a SQL script, then run psql from within a batch file. To avoid the password prompt, use [environment variables](https://www.postgresql.org/docs/current/libpq-envars.html) inside the batch file.
Truilus
