User Daniel Vérité

0 votes

How can I cleanly recreate the main postgresql cluster?

answered Aug 16 at 20:45

2 votes

Accepted

Issues using a psql -v variable with jsonb_set

answered Aug 15 at 12:12

1 vote

Using PostgreSQL

answered Aug 1 at 22:16

0 votes

PostgreSQL notifications aren't working

answered Jul 12 at 20:52

2 votes

Accepted

pg_dump.exe compared to MS SQL backup

answered Jul 7 at 11:46

3 votes

Accepted

psql \set an environment variable from the existing shell environment

answered May 25 at 11:48

1 vote

Accepted

Why is dblink nested function rolling back?

answered Apr 12 at 16:28

3 votes

Accepted

Why does my Postgres function always return the same value, regardless of input?

answered Apr 1 at 14:58

2 votes

Accepted

PostgreSQL doesn't sort according to `LC_COLLATE=C` even though DB is configured to

answered Mar 30 at 17:07

2 votes

Accepted

Index for searching in column where the column starts with the provided value

answered Mar 17 at 22:02

4 votes

Accepted

postgresql matching or converting utf-8 variant strings

answered Jan 5 at 13:51

2 votes

Accepted

Can two tables ever get the same OID on pg_class?

answered Dec 30, 2022 at 19:24

2 votes

Accepted

Postgres encoding issue - find values that have no equivalent in (client) encoding

answered Dec 14, 2022 at 20:58

2 votes

Accepted

pg_dump output formats

answered Dec 12, 2022 at 19:08

5 votes

Accepted

What does PostgreSQL Status active (exited) mean?

answered Dec 7, 2022 at 14:02

0 votes

Need to free up space by removing pg_wal files in Postgres

answered Nov 29, 2022 at 21:10

1 vote

How to query 30k of entries from an external data source by script

answered Oct 21, 2022 at 12:15

2 votes

Limit my ticker count to maximum 12 Months

answered Oct 18, 2022 at 20:07

2 votes

Accepted

OID release ranges for built-in (aka standard) database objects during PostgreSQL installation

answered Sep 9, 2022 at 23:05

4 votes

SQL Comments disappear with psql and `\e`

answered Sep 17, 2017 at 19:14

1 vote

Accepted

psql cannot connect to local database after changing data directory

answered Jul 15, 2022 at 14:54

3 votes

Accepted

PostgreSQL ESCAPE Quoting on TAB-delimited files: MySQL works, Pg doesn't, and I'm confused

answered Jul 11, 2022 at 17:07

1 vote

Accepted

Why this trigger is raising "record "old" is not assigned yet" exception?

answered Jun 29, 2022 at 17:13

1 vote

How to change initdb own messages localization?

answered Jun 26, 2022 at 14:36

1 vote

Accepted

How to upgrade Postgres minor version from 14.x to 14.4 in Ubuntu 20.04 LTS

answered Jun 17, 2022 at 9:47

2 votes

Accepted

postgresql change clustername but pg_lsclusters say it not changed

answered May 21, 2022 at 10:33

1 vote

Accepted

Inconsistent data when combining (LEFT) JOIN with SELECT FOR UPDATE

answered May 18, 2022 at 15:50

0 votes

Accepted

Importing CSV with a json array of strings in one of the column

answered May 17, 2022 at 18:02

3 votes

Accepted

Postgres Database server migration

answered Apr 19, 2022 at 10:42

5 votes

Accepted

Collation won't set when creating new database

answered Apr 18, 2022 at 15:36

Stack Exchange Network

471 Answers

How can I cleanly recreate the main postgresql cluster?

Issues using a psql -v variable with jsonb_set

Using PostgreSQL

PostgreSQL notifications aren't working

pg_dump.exe compared to MS SQL backup

psql \set an environment variable from the existing shell environment

Why is dblink nested function rolling back?

Why does my Postgres function always return the same value, regardless of input?

PostgreSQL doesn't sort according to `LC_COLLATE=C` even though DB is configured to

Index for searching in column where the column starts with the provided value

postgresql matching or converting utf-8 variant strings

Can two tables ever get the same OID on pg_class?

Postgres encoding issue - find values that have no equivalent in (client) encoding

pg_dump output formats

What does PostgreSQL Status active (exited) mean?

Need to free up space by removing pg_wal files in Postgres

How to query 30k of entries from an external data source by script

Limit my ticker count to maximum 12 Months

OID release ranges for built-in (aka standard) database objects during PostgreSQL installation

SQL Comments disappear with psql and `\e`

psql cannot connect to local database after changing data directory

PostgreSQL ESCAPE Quoting on TAB-delimited files: MySQL works, Pg doesn't, and I'm confused

Why this trigger is raising "record "old" is not assigned yet" exception?

How to change initdb own messages localization?

How to upgrade Postgres minor version from 14.x to 14.4 in Ubuntu 20.04 LTS

postgresql change clustername but pg_lsclusters say it not changed

Inconsistent data when combining (LEFT) JOIN with SELECT FOR UPDATE

Importing CSV with a json array of strings in one of the column

Postgres Database server migration

Collation won't set when creating new database