Skip to main content
Daniel Vérité's user avatar
Daniel Vérité's user avatar
Daniel Vérité's user avatar
Daniel Vérité
  • Member for 12 years, 3 months
  • Last seen this week
299 votes
Accepted

Granting a user account permission to create databases in PostgreSQL

78 votes

Measure the size of a PostgreSQL table row

74 votes
Accepted

Created user can access all databases in PostgreSQL without any grants

74 votes
Accepted

Why is a new user allowed to create a table?

61 votes
Accepted

Is there a maximum length constraint for a postgres query?

57 votes
Accepted

How to duplicate huge postgres table?

51 votes
Accepted

What is the impact of LC_CTYPE on a PostgreSQL database?

51 votes
Accepted

Preventing PostgreSQL from starting on boot in Ubuntu

49 votes
Accepted

ERROR: no schema has been selected to create in

33 votes
Accepted

pg_restore: [archiver] did not find magic string in file header

33 votes
Accepted

Are regular VACUUM ANALYZE still recommended under 9.1?

31 votes
Accepted

pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists

31 votes

How to get all roles that a user is a member of (including inherited roles)?

28 votes

How do I find out how far along my PostgreSQL query is?

27 votes
Accepted

PostgreSQL, display role members

24 votes
Accepted

Postgres incomplete startup packet error

22 votes
Accepted

pgBouncer works great but occasionally becomes unavailable

22 votes

How to verify SSL always being used on Postgresql 9.6

21 votes

Can IS DISTINCT FROM be combined with ANY or ALL somehow?

20 votes
Accepted

Why "SET LOCAL statement_timeout" does not work as expected with PostgreSQL functions?

20 votes
Accepted

Minimal grants for readonly single-table access on PostgreSQL

20 votes
Accepted

What is retrieved from disk during a query?

19 votes

Postgres RIGHT JOIN with custom array

19 votes
Accepted

How can I return multiple rows of records in PL/pgSQL

18 votes

Setting shared_buffers in postgresql.conf does not seem to take effect

18 votes

Postgres Dump To TXT File

18 votes
Accepted

Postgresql performed a "fast shutdown" by itself. Why? How was it able to do that?

16 votes
Accepted

PostgreSQL PREPARE query with IN () parameters

16 votes
Accepted

PostgreSQL user can not connect to server after changing password

16 votes
Accepted

Postgres - Encoding, Collation and CType

1
2 3 4 5
16