User Nick Barnes - Stack Overflow

126 votes

Accepted

Equivalence of from dual in PostgreSQL

answered May 18, 2015 at 12:49

104 votes

Accepted

ERROR: integer out of range on Postgresql

answered Jun 23, 2014 at 12:59

62 votes

Accepted

Postgres UPDATE with ORDER BY, how to do it?

answered Jun 21, 2017 at 7:53

44 votes

PostgreSQL column type conversion from bigint to bigserial

answered Aug 12, 2015 at 13:52

43 votes

Accepted

Postgresql fatal the database system is starting up - windows 10

answered Feb 28, 2019 at 10:38

39 votes

Accepted

Defining multi-line strings in psql

answered Jul 16, 2015 at 14:32

37 votes

Accepted

Postgres CREATE EXTENSION All Databases

answered Feb 9, 2017 at 15:04

32 votes

Accepted

Performance of NUMERIC type with high precisions and scales in PostgreSQL

answered Nov 19, 2016 at 12:18

29 votes

Accepted

PostgreSQL 9.3: Function is not unique error

answered Dec 23, 2015 at 8:40

29 votes

Accepted

How does postgresql lock tables when inserting and selecting?

answered Mar 6, 2018 at 12:08

28 votes

Accepted

Delphi passing parameters by reference or by value/copy

answered Mar 3, 2012 at 5:40

27 votes

Accepted

Can a Postgres Commit Exist in Procedure that has an Exception Block?

answered Mar 29, 2019 at 19:46

26 votes

Accepted

PostgreSQL Syntax error at or near FUNCTION on create trigger

answered Aug 8, 2019 at 23:25

26 votes

Postgres returns [null] instead of [] for array_agg of join table

answered Jun 29, 2015 at 13:45

24 votes

Accepted

SML: difference between type and datatype

answered Nov 6, 2013 at 10:14

22 votes

Accepted

How to copy a csv file from a url to Postgresql

answered Jan 17, 2017 at 13:33

21 votes

Accepted

Psycopg2 peer authentication for user postgres

answered Nov 11, 2016 at 2:39

21 votes

Accepted

Counter cache column in PostgreSQL

answered Jul 21, 2014 at 23:46

20 votes

What is the unit of PostgreSQL shared_buffers?

answered Jul 3, 2014 at 10:04

20 votes

Accepted

PostgreSQL - RETURNING INTO array

answered Nov 18, 2014 at 22:49

20 votes

Accepted

Suppressing "Notice: Relation exists" when using "CREATE ... IF NOT EXISTS"

answered Oct 2, 2014 at 10:35

19 votes

Accepted

Postgresql - Dump database with x tables - schema only but data from one table

answered Jan 24, 2017 at 10:46

18 votes

Accepted

PostgreSQL: deadlock detected SELECT FOR UPDATE in transaction

answered Jun 29, 2018 at 9:22

17 votes

Accepted

Default isolation level for transaction (@atomic) with Django and PostgreSQL

answered Feb 19, 2017 at 21:08

16 votes

Accepted

Remove curly braces from xpath output in Postgres

answered Sep 4, 2014 at 22:47

16 votes

Accepted

java string permutations and combinations lookup

answered Feb 4, 2012 at 7:21

15 votes

Accepted

PostgreSQL's Repeatable Read Allows Phantom Reads But its document says that it does not allow

answered Apr 4, 2019 at 14:30

15 votes

Accepted

Is it possible to define global variables in postgresql

answered Jul 9, 2015 at 13:23

14 votes

Accepted

How to avoid dead lock while using advisory locks in postgresql

answered Dec 20, 2016 at 10:35

14 votes

How to use IN clause with PreparedStatement in PostgreSQL

answered Apr 29, 2016 at 5:27

Collectives™ on Stack Overflow

360 Answers

Equivalence of from dual in PostgreSQL

ERROR: integer out of range on Postgresql

Postgres UPDATE with ORDER BY, how to do it?

PostgreSQL column type conversion from bigint to bigserial

Postgresql fatal the database system is starting up - windows 10

Defining multi-line strings in psql

Postgres CREATE EXTENSION All Databases

Performance of NUMERIC type with high precisions and scales in PostgreSQL

PostgreSQL 9.3: Function is not unique error

How does postgresql lock tables when inserting and selecting?

Delphi passing parameters by reference or by value/copy

Can a Postgres Commit Exist in Procedure that has an Exception Block?

PostgreSQL Syntax error at or near FUNCTION on create trigger

Postgres returns [null] instead of [] for array_agg of join table

SML: difference between type and datatype

How to copy a csv file from a url to Postgresql

Psycopg2 peer authentication for user postgres

Counter cache column in PostgreSQL

What is the unit of PostgreSQL shared_buffers?

PostgreSQL - RETURNING INTO array

Suppressing "Notice: Relation exists" when using "CREATE ... IF NOT EXISTS"

Postgresql - Dump database with x tables - schema only but data from one table

PostgreSQL: deadlock detected SELECT FOR UPDATE in transaction

Default isolation level for transaction (@atomic) with Django and PostgreSQL

Remove curly braces from xpath output in Postgres

java string permutations and combinations lookup

PostgreSQL's Repeatable Read Allows Phantom Reads But its document says that it does not allow

Is it possible to define global variables in postgresql

How to avoid dead lock while using advisory locks in postgresql

How to use IN clause with PreparedStatement in PostgreSQL