Ezequiel Tolnay's user avatar
Ezequiel Tolnay's user avatar
Ezequiel Tolnay's user avatar
Ezequiel Tolnay
  • Member for 7 years, 9 months
  • Last seen more than a week ago
30 votes

pg_upgrade unrecognized configuration parameter "unix_socket_directory"

28 votes
Accepted

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

12 votes

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

7 votes
Accepted

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

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

5 votes
Accepted

Converting SQL SERVER Procedure to POSTGRESQL

5 votes

How to select mutiple values with like clause

5 votes
Accepted

Require JSON to have an element

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

MIN(column) with subquery

4 votes

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

4 votes

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

4 votes

Custom ID Numbering - fast way on insert?

4 votes
Accepted

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

3 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

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

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

3 votes
Accepted

Bus timetable Database structure

3 votes

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

3 votes
Accepted

PostgreSQL 9.3: Aggregate collection of JSON arrays

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

1
2 3 4 5 6