JSONB: text contains array value?

postgresql

Anonymous 1800Anonymous 1800

3The expression `attributes->>'owning_groups'`

Truilus

Postgresql 9.6 - Multiply the previous rows and answer in the next row3

postgresql-9.6

greatmangreatman

Primary key to composite key without knowing constraint name3

postgresql

Anonymous 1800Anonymous 1800

6If 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 fails17

postgresql

Marc.2377Marc.2377

6The 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

PeterVandivierPeterVandivier

Merging/combining values doesn't work as expected11

postgresql-11

khakha

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 structure1

postgresql-10

Anonymous 1800Anonymous 1800

5As 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

khakha

7Put 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

Does using an array of jsonb ever make sense?3

postgresql

TruilusTruilus

2I'm really glad I read all the way to the end of the question:

Jack Douglas

What does it mean when pg_stat_activity.datname is NULL?

postgresql

PeterVandivierPeterVandivier