András Váczi's user avatar
András Váczi's user avatar
András Váczi's user avatar
András Váczi
  • Member for 12 years, 2 months
  • Last seen more than a month ago
  • Hungary
228 votes
Accepted

Granting access to all tables for a user

74 votes
Accepted

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

69 votes
Accepted

Permission denied in file trying to import

66 votes
Accepted

Why does Postgres generate an already used PK value?

52 votes
Accepted

Get all partition names for a table

42 votes
Accepted

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

32 votes
Accepted

Why would you index text_pattern_ops on a text column?

29 votes
Accepted

How do I query the running pg_hba configuration?

28 votes

GRANT USAGE on all schemas in a database?

28 votes
Accepted

PostgreSQL - insert/update violates foreign key constraints

23 votes
Accepted

Optimal way to ignore duplicate inserts?

22 votes
Accepted

Get 10th and 90th percentile by customer

22 votes
Accepted

Same function in SELECT and WHERE clause

21 votes
Accepted

Copy PostgreSQL database from a remote server

21 votes
Accepted

PostgreSQL Index Caching

20 votes
Accepted

Does PostgreSQL optimize adding columns with non-NULL DEFAULTs?

20 votes

Execute system commands in postgresql

20 votes
Accepted

psql: FATAL: Peer authentication failed for user

19 votes
Accepted

Trigger to UPDATE after UPDATE?

19 votes
Accepted

Why do I need to cast NULL to column type?

18 votes

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

17 votes
Accepted

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

17 votes
Accepted

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

17 votes
Accepted

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

17 votes
Accepted

PostgreSQL filtering on array length inside JSON

16 votes
Accepted

Why is ACCESS EXCLUSIVE LOCK necessary in PostgreSQL?

15 votes
Accepted

Postgres jsonb column or standard normalized table?

15 votes

Transactions within a Transaction

15 votes

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

15 votes

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

1
2 3 4 5
14