PostgreSQL Database Migration How can I migrate data from on PostgreSQL database to another PostgreSQL database?  Is there any technique to migrate data with SQL scripting?
If you migrate to a new version of PostgreSQL use pg_dump from the latest version. Anyway, this is a simple way to dump and restore :

pg_dump -U username -h hostname source_database | psql -U username target_database