7,044 reputation
31640
bio website
location Berlin, Germany
age 39
visits member for 2 years, 10 months
seen 6 hours ago

Dec
15
revised create insertion rule on view returning id
added 37 characters in body
Dec
12
revised Translate psql meta-command to SQL
edited title
Dec
6
revised Creating a db for time slots in a day
added 58 characters in body
Nov
26
revised Postgresql - Streaming replication - STONITH
added 20 characters in body
Nov
11
revised Postgresql doesn't accept replication connection
added 82 characters in body
Nov
10
revised PostgreSQL roles versus users, grant permissions
added 266 characters in body
Nov
10
revised PostgreSQL: Creation date of a table
added 6 characters in body
Nov
7
revised why pg_restore ignores --create ? Error: failed: FATAL: database “new_db” does not exist
deleted 10 characters in body
Nov
7
revised PostgreSQL: Creation date of a table
formatting
Oct
30
revised Postgres: modify existing search_path (preserve current values)
adding the bonus answer
Oct
29
revised Why does 'plpgsql' not appear in the pg_extension table?
added 72 characters in body
Oct
27
revised Why does a select statement dirty cache bufferes in postgres
added the explanation from the comment plus cleaned up HTH
Sep
12
revised get row count of last select query
added 12 characters in body
Aug
29
revised PostgreSQL Sequential Scan instead of Index Scan Why?
edited body
Aug
17
revised Searching a big table for a few results without scanning the whole table
remove duplication remove duplication
Jul
25
revised Why is my composite index not used for this table?
fixed myself :)
Jul
25
revised Custom personal monitor sql by writing the .psqlrc file
added 1 character in body
Jul
22
revised Conditionally sum a column based on a mod result
deleted 40 characters in body
Jul
15
revised On Heroku in production, how can I copy database A to database B on command?
edited tags
Jul
13
revised Connect to PgAdmin III via localhost
edited tags