Craig Ringer's user avatar
Craig Ringer's user avatar
Craig Ringer's user avatar
Craig Ringer
  • Member for 11 years, 11 months
  • Last seen more than a week ago
294 votes
Accepted

How to get the name of the current database from within PostgreSQL?

106 votes
Accepted

Understanding "bitmap heap scan" and "bitmap index scan"

101 votes

Are WHERE clauses applied in the order they are written?

97 votes
Accepted

PostgreSQL: Remove password requirement for user postgres

63 votes
Accepted

How should I index a UUID in Postgres?

62 votes
Accepted

Optimizing a Postgres query with a large IN

62 votes
Accepted

JSONB with indexing vs. hstore

62 votes
Accepted

Can listen_addresses really be set to a list?

61 votes

How to duplicate the database in postgresql?

61 votes
Accepted

Superuser is not permitted to login

60 votes
Accepted

Is a Postgres long-running query aborted if the connection is lost/broken?

58 votes
Accepted

PostgreSQL roles versus users, grant permissions

49 votes
Accepted

Getting last modification date of a PostgreSQL database table

45 votes
Accepted

restoring Postgres database: pg_restore -vs- just using psql

44 votes
Accepted

Multiple primary keys in PostgreSQL

43 votes
Accepted

Forgotten PostgreSQL Windows password

40 votes
Accepted

What happens in PostgreSQL checkpoint?

38 votes
Accepted

How to run recurring tasks on Postgresql without an external cron-like tool?

37 votes
Accepted

Export remote Postgres table to CSV file on local machine

36 votes
Accepted

PostgreSQL: Immutable, Volatile, Stable

34 votes
Accepted

PostgreSQL procedural languages - differences between PL/pgSQL and SQL

31 votes

Why is a new user allowed to create a table?

31 votes
Accepted

Is PostgreSQL replication production ready?

30 votes
Accepted

How to list all table columns in sorted order on Postgres?

28 votes
Accepted

How to view the query of another session in pg_stat_activity without being super user?

27 votes

Check if postgresql database exists (case insensitive way)

26 votes
Accepted

PostgreSQL Common Table Expressions vs a temporary table?

26 votes
Accepted

How to correctly implement optimistic locking in MySQL

26 votes
Accepted

Running pg_dump on a hot standby server?

26 votes
Accepted

How can I generate a random bytea

1
2 3 4 5
23