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
Does using an array of jsonb ever make sense?
3
postgresql
Truilus
Truilus
2
I'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
PeterVandivier
PeterVandivier
UNION ALL + LIMIT - unintuitive behaviour with subselect
postgresql
PeterVandivier
PeterVandivier
3
The docs are a bit vague about this. In the ["Combining Queries"](https://www.postgresql.org/docs/13/queries-union.html) section (which discusses `UNION`/`INTERSECT`/`EXCEPT`) they state:
Jack Douglas
3
Without explicit parentheses, the second `LIMIT` is scoped to the batch, not the statement. Consider the `EXPLAIN`
PeterVandivier
Reverse string by parts with strict ordering
postgresql
PeterVandivier
PeterVandivier
7
If you want to guarantee ordering (and you should), you can use [with ordinality](https://www.postgresql.org/docs/12/queries-table-expressions.html#QUERIES-TABLEFUNCTIONS) since version 9.4, along with an aggregate with [order by](https://www.postgresql.org/docs/12/sql-expressions.html#SYNTAX-AGGREGATES):
Jack Douglas
4
I would probably use a scalar sub-select:
Truilus
How to connect SQLeo to an online database?
postgresql
David
David
5
With some [pointers from the SQLeo developer](https://sourceforge.net/p/sqleo/discussion/general/thread/622c79e069/#76c7), I managed to sort this. The more generic form of my problem is **using an SSH tunnel to connect securely to a remote database**.
David
