PostgreSQL import / export database

Dump database:

$ pg_dump database_name > database_name.sql

Import database:

$ psql database_name < database_file.sql