User Ezequiel Tolnay

32 votes

Accepted

How can I dump all tables to CSV for a PostgreSQL schema?

answered May 2, 2016 at 3:01

31 votes

pg_upgrade unrecognized configuration parameter "unix_socket_directory"

answered Dec 24, 2014 at 1:28

12 votes

UPSERT with ON CONFLICT using values from source table in the UPDATE part

answered Apr 6, 2016 at 9:02

8 votes

Accepted

Postgresql error: failed to re-find parent key in index

answered Apr 20, 2016 at 7:28

8 votes

Accepted

Database in postgresql with missing rows, how to fill the missing rows with a backup copy?

answered Jun 3, 2016 at 1:18

6 votes

Tricking SQL server into thinking it's a different date

answered Jun 8, 2016 at 5:39

6 votes

Accepted

Group daily schedule into [Start date; End date] intervals with the list of week days

answered Apr 27, 2016 at 5:09

6 votes

Accepted

Can we export data from PostgreSQL to xlsx file?

answered May 4, 2016 at 0:37

6 votes

Accepted

Converting SQL SERVER Procedure to POSTGRESQL

answered May 16, 2016 at 7:30

5 votes

How to select mutiple values with like clause

answered Apr 11, 2016 at 4:51

5 votes

Accepted

Require JSON to have an element

answered Jun 16, 2016 at 4:45

4 votes

Accepted

Within a trigger is there a way to tell if an update or insert came from a trigger or not?

answered May 30, 2018 at 6:21

4 votes

Is it possible for a weak entity, already related to a strong entity, to get related to another weak entity in an ER diagram?

answered Apr 11, 2016 at 7:39

4 votes

Custom ID Numbering - fast way on insert?

answered Apr 8, 2016 at 8:57

4 votes

MIN(column) with subquery

answered Apr 15, 2016 at 0:41

4 votes

How to check if a postgresql backup is finished or not?

answered Apr 4, 2016 at 4:11

4 votes

How would I select distinct records from the same table on two different databases?

answered Apr 1, 2016 at 6:26

4 votes

Accepted

Select tables on column entry in schema (with many tables)

answered May 16, 2016 at 6:20

3 votes

best way to avoid redundant aggregate functions and/or group by columns

answered May 17, 2016 at 6:21

3 votes

Postgres database deadlock issue

answered May 16, 2016 at 5:04

3 votes

How to format a phone number in a SELECT statement?

answered May 18, 2016 at 1:06

3 votes

Accepted

How to append datetime in filename in postgresql

answered May 3, 2016 at 9:28

3 votes

Accepted

Postgres: set client encoding default

answered Apr 28, 2016 at 0:00

3 votes

Accepted

How can I optimize a query with multiple derived tables containing `IN` and `GROUP BY`?

answered May 3, 2016 at 1:34

3 votes

Can we commit the transaction when the sql server trigger fails?

answered May 3, 2016 at 1:58

3 votes

Cross-cutting I18N native support in databases

answered Apr 14, 2016 at 1:25

3 votes

Accepted

Filtering special characters in to_tsquery

answered Apr 12, 2016 at 6:51

3 votes

open/execute huge sql file

answered Apr 11, 2016 at 5:09

3 votes

How to use RETURNS TABLE with an existing table in PostgreSQL?

answered Apr 15, 2016 at 5:35

3 votes

Accepted

Bus timetable Database structure

answered Apr 18, 2016 at 3:50

Stack Exchange Network

167 Answers

How can I dump all tables to CSV for a PostgreSQL schema?

pg_upgrade unrecognized configuration parameter "unix_socket_directory"

UPSERT with ON CONFLICT using values from source table in the UPDATE part

Postgresql error: failed to re-find parent key in index

Database in postgresql with missing rows, how to fill the missing rows with a backup copy?

Tricking SQL server into thinking it's a different date

Group daily schedule into [Start date; End date] intervals with the list of week days

Can we export data from PostgreSQL to xlsx file?

Converting SQL SERVER Procedure to POSTGRESQL

How to select mutiple values with like clause

Require JSON to have an element

Within a trigger is there a way to tell if an update or insert came from a trigger or not?

Is it possible for a weak entity, already related to a strong entity, to get related to another weak entity in an ER diagram?

Custom ID Numbering - fast way on insert?

MIN(column) with subquery

How to check if a postgresql backup is finished or not?

How would I select distinct records from the same table on two different databases?

Select tables on column entry in schema (with many tables)

best way to avoid redundant aggregate functions and/or group by columns

Postgres database deadlock issue

How to format a phone number in a SELECT statement?

How to append datetime in filename in postgresql

Postgres: set client encoding default

How can I optimize a query with multiple derived tables containing `IN` and `GROUP BY`?

Can we commit the transaction when the sql server trigger fails?

Cross-cutting I18N native support in databases

Filtering special characters in to_tsquery

open/execute huge sql file

How to use RETURNS TABLE with an existing table in PostgreSQL?

Bus timetable Database structure