Reputation
12,542
Next tag badge:
733/1000 score
223/200 answers
Badges
7 32 59
Newest
 sql
Impact
~665k people reached

Mar
18
revised Does the PostgreSQL COPY command have the option of choosing with fields to map the CSV columns to?
added 77 characters in body
Mar
18
comment Moving extensions in AWS RDS (Postgres)
That sounds bad, yes.
Mar
18
answered Does the PostgreSQL COPY command have the option of choosing with fields to map the CSV columns to?
Mar
17
comment How to view phppgadmin as the application name in PostgreSQL's log files?
Another idea is setting the PGAPPNAME environmental variable: postgresql.org/docs/9.1/static/…
Mar
17
comment How to view phppgadmin as the application name in PostgreSQL's log files?
I'd try to specify the application name in config.inc.php, in the relevant $conf['servers'] array. The parameter to libpq is application_name, try this one. You will have to reconnect to see if it works.
Mar
17
revised Create dynamic WHERE clause from a JSON field
added 279 characters in body
Mar
17
revised Create dynamic WHERE clause from a JSON field
added 405 characters in body
Mar
17
answered Create dynamic WHERE clause from a JSON field
Mar
17
revised Create dynamic WHERE clause from a JSON field
fix JSON
Mar
17
revised Create dynamic WHERE clause from a JSON field
added 13 characters in body; edited tags; edited title
Mar
17
revised Postgresql 9.4 replication not working
edited tags
Mar
17
comment Postgresql 9.4 replication not working
How do you see replication is not working? It clearly tells 'started streaming WAL from primary'...
Mar
17
revised Extract MIN and MAX values related to datetime values on Postgres 9+
added 68 characters in body
Mar
16
comment Moving extensions in AWS RDS (Postgres)
When logged in, check the ownership of the extension using SELECT extname, extowner::regrole FROM pg_catalog.pg_extension; (assuming you are on 9.5 - in any other case, you have to join pg_authid to get the role name). The rds_superuser is not really a superuser.
Mar
16
revised Moving extensions in AWS RDS (Postgres)
added 11 characters in body
Mar
16
reviewed Reopen Database table(s) to record investor activity
Mar
16
reviewed Close Jobs scheduling to fetch data from multiple servers using SQL Server Agent
Mar
16
reviewed Reviewed Error from Program Compatibility Assistant when installing SQL Server 2008
Mar
16
comment Postgresql string array vs join for user management schema?
Why do you want to save a join? Wait, you don't. Try to measure the performance difference of both approaches. Just add a bunch of fake users, and measure.
Mar
16
comment Postgresql string array vs join for user management schema?
The first. Only the first.