User Ezequiel Tolnay

30 votes

Accepted

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

answered May 2, 2016 at 3:01

30 votes

pg_upgrade unrecognized configuration parameter "unix_socket_directory"

answered Dec 24, 2014 at 1:28

3 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

2 votes

Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL

answered Apr 10, 2018 at 1:01

1 vote

Scalable way to track who's viewed a post?

answered May 19, 2016 at 3:59

2 votes

Migrating master databases between clusters by detaching/attaching them

answered Jun 4, 2017 at 4:54

3 votes

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

answered Apr 15, 2016 at 5:35

0 votes

Postgres 9.5 import to MSSQL Server 2012 r2 verification issue

answered Jul 29, 2016 at 5:31

0 votes

How to create a Unique (Index) constraint across multiple tables?

answered Jul 12, 2016 at 6:02

1 vote

Remove accidental duplicates in PK table, cascade changes to FK table

answered Apr 21, 2016 at 4:40

0 votes

How to copy part of a database with inconsistent privileges?

answered Jun 20, 2016 at 6:32

5 votes

Accepted

Require JSON to have an element

answered Jun 16, 2016 at 4:45

3 votes

PostgreSQL not using index scan when a second ORDER BY column is present

answered Jun 14, 2016 at 1:54

1 vote

Accepted

Postgresql perl : "NOTICE: elseif should be elsif at line ..."

answered Jun 8, 2016 at 8:51

3 votes

Accepted

which time period covers date string over datetime column

answered Jun 8, 2016 at 7:00

0 votes

Postgres inherit from one role and not another

answered Jun 8, 2016 at 6:19

0 votes

Best practice for multiple 0,1 to many relationships

answered Jun 8, 2016 at 5:45

6 votes

Tricking SQL server into thinking it's a different date

answered Jun 8, 2016 at 5:39

2 votes

Is it possible to set PostgreSQL roles with privileges this way?

answered Jun 7, 2016 at 7:12

1 vote

Can I grant privileges to a Postgres user on all schemas belonging to a database with one command or script?

answered Jun 6, 2016 at 8:08

0 votes

Designing database containing code metadata

answered Jun 6, 2016 at 7:55

0 votes

Accepted

Compare two sets with a quantity field

answered Jun 3, 2016 at 1:32

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

0 votes

Insert data into oracle table with loop?

answered Jun 2, 2016 at 7:57

0 votes

Accepted

Count approximation with where clause

answered Jun 2, 2016 at 2:54

1 vote

Accepted

Combine individual sensor values into an overall value with correction factors

answered Jun 2, 2016 at 1:45

1 vote

Accepted

how do I change regexp_substr(to_char(bar), '^.*?$', 1, 1, 'm') to only read 132 characters each time

answered May 4, 2016 at 2:48

1 vote

SQL Server to MySQL migration, replace '\xA0' with a regular space

answered Jun 1, 2016 at 0:49

1 vote

Mysql Order , Select highest value item and update to another table

answered Jun 1, 2016 at 0:36

3 votes

Accepted

Postgres LEFT JOIN with recurring dates and users

answered May 27, 2016 at 4:54

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"

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

Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL

Scalable way to track who's viewed a post?

Migrating master databases between clusters by detaching/attaching them

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

Postgres 9.5 import to MSSQL Server 2012 r2 verification issue

How to create a Unique (Index) constraint across multiple tables?

Remove accidental duplicates in PK table, cascade changes to FK table

How to copy part of a database with inconsistent privileges?

Require JSON to have an element

PostgreSQL not using index scan when a second ORDER BY column is present

Postgresql perl : "NOTICE: elseif should be elsif at line ..."

which time period covers date string over datetime column

Postgres inherit from one role and not another

Best practice for multiple 0,1 to many relationships

Tricking SQL server into thinking it's a different date

Is it possible to set PostgreSQL roles with privileges this way?

Can I grant privileges to a Postgres user on all schemas belonging to a database with one command or script?

Designing database containing code metadata

Compare two sets with a quantity field

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

Insert data into oracle table with loop?

Count approximation with where clause

Combine individual sensor values into an overall value with correction factors

how do I change regexp_substr(to_char(bar), '^.*?$', 1, 1, 'm') to only read 132 characters each time

SQL Server to MySQL migration, replace '\xA0' with a regular space

Mysql Order , Select highest value item and update to another table

Postgres LEFT JOIN with recurring dates and users