Reputation
19,990
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
4 37 70
Impact
~1.5m people reached

7h
answered Missing / Orphan Indexes?
9h
revised Looking for a better way with Reporting Db server
edited tags
9h
answered Is there a way in PostgreSQL to set an default owner for all future create table statements in a session
9h
revised Is there a way in PostgreSQL to set an default owner for all future create table statements in a session
deleted 23 characters in body; edited tags; edited title
14h
comment Creating mini postgresql dump
This tool claims to be able to do that: jailer.sourceforge.net
1d
comment Serial Function - PostgreSQL 9.2
If the column can't be null, then why don't you just define it as NOT NULL and a default value?
1d
revised Serial Function - PostgreSQL 9.2
deleted 10 characters in body
2d
comment PL/pgSQL trigger function syntax error at END;
ELSE IF --> ELSIF: postgresql.org/docs/current/static/…
2d
comment Security of streaming replication?
No. With streaming replication the WAL segments are sent directly to the slave through a regular connection, not by writing files.
Apr
29
comment Security of streaming replication?
That wouldn't be streaming replication. That's just WAL shipping, isn't it?
Apr
28
comment Make a (copy of a) postgis database available to customer?
Create a hot-standby with streaming replication: postgresql.org/docs/current/static/…
Apr
27
reviewed Edit Where can I find the SQL Server to download?
Apr
27
revised Where can I find the SQL Server to download?
edited grammar
Apr
27
answered Postgres: set client encoding default
Apr
27
revised ALTER SESSION from a Control File
edited tags
Apr
27
revised How can I drop an index on all partitions?
edited tags
Apr
27
revised cannot call json_array_elements on a scalar
added 67 characters in body; edited tags
Apr
27
answered Can't figure out how to update a column in one table based on multiple boolean values in another table in postgresql
Apr
27
revised Extract string in PostgreSQL 9.2
added 280 characters in body
Apr
27
comment Extract string in PostgreSQL 9.2
You are right it does not need to be that complicated (or tricky). A simple split_part() will do.