Exporting and Importing Data into Postgres

To export a postgres database

 pg_dump mydb > db.sql

To reload such a script into a (freshly created) database named newdb:

$ psql -d newdb -f db.sql