Ezequiel Tolnay's user avatar
Ezequiel Tolnay's user avatar
Ezequiel Tolnay's user avatar
Ezequiel Tolnay
  • Member for 9 years, 2 months
  • Last seen this week
33 votes
Accepted

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

31 votes

pg_upgrade unrecognized configuration parameter "unix_socket_directory"

12 votes

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

8 votes
Accepted

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

8 votes
Accepted

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

6 votes

Tricking SQL server into thinking it's a different date

6 votes
Accepted

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

6 votes
Accepted

Can we export data from PostgreSQL to xlsx file?

6 votes
Accepted

Converting SQL SERVER Procedure to POSTGRESQL

5 votes

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

5 votes

How to select mutiple values with like clause

5 votes
Accepted

Require JSON to have an element

4 votes
Accepted

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

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?

4 votes

Custom ID Numbering - fast way on insert?

4 votes

MIN(column) with subquery

4 votes

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

4 votes
Accepted

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

4 votes

How to format a phone number in a SELECT statement?

3 votes

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

3 votes

Postgres database deadlock issue

3 votes
Accepted

How to append datetime in filename in postgresql

3 votes
Accepted

Postgres: set client encoding default

3 votes
Accepted

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

3 votes

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

3 votes

Cross-cutting I18N native support in databases

3 votes
Accepted

Filtering special characters in to_tsquery

3 votes

open/execute huge sql file

3 votes

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

3 votes
Accepted

Bus timetable Database structure

1
2 3 4 5 6