6,464 reputation
31436
bio website
location Berlin, Germany
age 38
visits member for 2 years, 6 months
seen 44 mins ago

1h
answered Custom personal monitor sql by writing the .psqlrc file
2d
answered Will insert and update query wait while a table is being vacummed?
Jul
11
answered Update new column with value from old columns for all the rows
Jul
10
answered Organizing Database Objects in a Database that are not part of the systems original Database Objects?
Jul
10
answered How to log DML statements executed by a pl/pgsql function?
Jul
10
answered Is there a way I can use currval() without selecting it more than once?
Jul
10
answered Does PostgreSQL write first to WAL and then to data files?
Jul
3
answered Postgres : Executing SELECT within a transaction does not return most recent rows
Jun
18
answered Difference between pg_column_size(table.*) and pg_column_size(table.col1) + pg_column_size (table.col2)
Jun
5
answered How can I get PostgreSQL to not advance sequences when COPY fails?
May
20
answered Postgres ODBC driver versions
May
15
answered PostgreSQL Function: How to refer to individual column in record return by function
May
12
answered How can I enable logging for a single function in PostgreSQL?
Apr
4
answered Join table on some conditions
Mar
27
answered Add 0 into array_agg if there is no matching data
Mar
15
answered Has postgresql a fast add column optimization?
Mar
11
answered How can streaming replication be kept lagged by a certain 'delay' time?
Mar
10
answered SELECT DISTINCT with another table
Mar
7
answered Why does this limit make the postgres planner use a much slower index scan instead of a much faster bitmap heap/index scan?
Mar
5
answered Removing records from database periodically that surpass timeline