Often I need to create copies of databases so I can test a new stored procedure or if what I’m doing could get in the way of other developers. The easiest way I’ve found to make a personal clone of a PostgreSQL database is by command line using psql, pg_dump and pg_restore. First back up [...]
Posts tagged psql
PostgreSQL with Python using PyGreSQL
New Ubuntu boxes wont have PostgreSQL unless specified at OS installation. Here is the official guide for installation and set up of PostgreSQL database. If your using a gui then for convenience sake its worth getting ‘pgadmin3‘. sudo apt-get install postgresql pgadmin3 Most of my work with Postgre uses ‘pgdb’ from the PyGreSQL module. Its DB-API compliant which is [...]
The thoughts and code of Alex.