6,979 reputation
31439
bio website
location Berlin, Germany
age 38
visits member for 2 years, 10 months
seen 2 days ago

Nov
6
answered Assign to NEW by key in a Postgres trigger
Nov
3
answered Order specific columns in json_agg
Oct
29
answered Why does 'plpgsql' not appear in the pg_extension table?
Oct
28
answered Can i have one foreign key to both parent and it's childs in postgresql?
Oct
24
answered Transactions within a Transaction
Jul
25
answered Custom personal monitor sql by writing the .psqlrc file
Jul
23
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