Monthly Archives: October 2012

PostgreSQL useful tips

I am posting some of the PostgreSQL commands which I use frequently. Create a new database name testdb # createdb <dbname> e.g: Remove a PostgreSQL database # dropdb <dbname> e.g: Backing up a PostgreSQL database Restoring PostgreSQL database from back up dump Writing query output to a CSV file: After this operation all the query results… Read More »