postgres: random useful things

Run sql statements from the command line, use the -c flag


create a random value


crazy updates using regexp_matches

postgres: terminate all database connections

Using psql from the command line you can terminate all connections to a database

Comes in handy when you want to do things like restore your staging or development database

Resources

• http://www.postgresql.org/docs/9.1/static/reference-client.html 
• http://blog.gahooa.com/2010/11/03/how-to-force-drop-a-postgresql-database-by-killing-off-connection-processes/