User András Váczi

233 votes

Accepted

Granting access to all tables for a user

answered Feb 1, 2013 at 12:36

74 votes

Accepted

postgresql: how do I dump and restore roles for a cluster?

answered Jul 17, 2012 at 7:52

69 votes

Accepted

Permission denied in file trying to import

answered Dec 4, 2012 at 13:27

68 votes

Accepted

Why does Postgres generate an already used PK value?

answered Jul 11, 2013 at 7:37

53 votes

Accepted

Get all partition names for a table

answered Apr 22, 2013 at 14:45

42 votes

Accepted

How to set Postgresql database to see date as "MDY" permanently

answered Jun 21, 2012 at 18:04

32 votes

Accepted

Why would you index text_pattern_ops on a text column?

answered Nov 22, 2013 at 18:13

31 votes

Accepted

How do I query the running pg_hba configuration?

answered Jul 24, 2017 at 15:29

28 votes

GRANT USAGE on all schemas in a database?

answered May 19, 2015 at 15:07

28 votes

Accepted

PostgreSQL - insert/update violates foreign key constraints

answered Nov 23, 2012 at 8:56

23 votes

Accepted

Optimal way to ignore duplicate inserts?

answered Dec 17, 2012 at 9:11

22 votes

Accepted

Same function in SELECT and WHERE clause

answered Jan 25, 2018 at 14:20

22 votes

Accepted

psql: FATAL: Peer authentication failed for user

answered Mar 3, 2016 at 9:16

22 votes

Accepted

Get 10th and 90th percentile by customer

answered Jul 9, 2015 at 12:32

21 votes

Accepted

Copy PostgreSQL database from a remote server

answered Dec 19, 2013 at 9:51

21 votes

Accepted

PostgreSQL Index Caching

answered Oct 5, 2012 at 22:15

20 votes

Execute system commands in PostgreSQL

answered Feb 4, 2016 at 9:55

20 votes

Accepted

Why do I need to cast NULL to column type?

answered Jan 25, 2019 at 7:43

20 votes

Accepted

Does PostgreSQL optimize adding columns with non-NULL DEFAULTs?

answered Mar 15, 2014 at 19:48

19 votes

Accepted

Trigger to UPDATE after UPDATE?

answered Jul 3, 2012 at 17:00

18 votes

Accepted

Does the PostgreSQL COPY command have the option of choosing which fields to map the CSV columns to?

answered Mar 18, 2016 at 9:28

18 votes

How to conditionally stop a psql script (based on a variable value)?

answered Sep 25, 2012 at 8:00

17 votes

Accepted

PostgreSQL filtering on array length inside JSON

answered Sep 16, 2016 at 7:16

17 votes

Accepted

Can the 'returning' clause return source columns that are not inserted?

answered Sep 29, 2013 at 6:35

17 votes

Accepted

Why 't' and 'f' instead of TRUE and FALSE

answered Sep 16, 2015 at 13:48

16 votes

Accepted

Why is ACCESS EXCLUSIVE LOCK necessary in PostgreSQL?

answered Oct 20, 2016 at 15:24

15 votes

column {table_name} of relation {table_name} does not exist SQL state: 42703

answered Aug 3, 2016 at 9:13

15 votes

Accepted

Postgres jsonb column or standard normalized table?

answered Nov 8, 2018 at 19:08

15 votes

Transactions within a Transaction

answered Oct 24, 2014 at 13:49

15 votes

How do I set the external editor for PostgreSQL's psql client?

answered Oct 3, 2012 at 10:10

Stack Exchange Network

417 Answers

Granting access to all tables for a user

postgresql: how do I dump and restore roles for a cluster?

Permission denied in file trying to import

Why does Postgres generate an already used PK value?

Get all partition names for a table

How to set Postgresql database to see date as "MDY" permanently

Why would you index text_pattern_ops on a text column?

How do I query the running pg_hba configuration?

GRANT USAGE on all schemas in a database?

PostgreSQL - insert/update violates foreign key constraints

Optimal way to ignore duplicate inserts?

Same function in SELECT and WHERE clause

psql: FATAL: Peer authentication failed for user

Get 10th and 90th percentile by customer

Copy PostgreSQL database from a remote server

PostgreSQL Index Caching

Execute system commands in PostgreSQL

Why do I need to cast NULL to column type?

Does PostgreSQL optimize adding columns with non-NULL DEFAULTs?

Trigger to UPDATE after UPDATE?

Does the PostgreSQL COPY command have the option of choosing which fields to map the CSV columns to?

How to conditionally stop a psql script (based on a variable value)?

PostgreSQL filtering on array length inside JSON

Can the 'returning' clause return source columns that are not inserted?

Why 't' and 'f' instead of TRUE and FALSE

Why is ACCESS EXCLUSIVE LOCK necessary in PostgreSQL?

column {table_name} of relation {table_name} does not exist SQL state: 42703

Postgres jsonb column or standard normalized table?

Transactions within a Transaction

How do I set the external editor for PostgreSQL's psql client?