Postgresql restore from dump

psql -U postgres -h localhost -p 5432 -f data_dump.sql

Postgresql dump and restore db

#To dump a database called mydb into a SQL-script file:
pg_dump mydb > db.sql

#To reload such a script into a (freshly created) database named newdb:
psql -d newdb -f db.sql

Source: stackoverflow.com

Similar codes

5 votes149 views4 answers
SQL Order of execution
SQL
28 votes135 views4 answers
Show tables mysql
SQL
0 vote145 views2 answers
How to generate a unique random number in mysql
SQL
2 votes149 views3 answers
Replace null in sql
SQL
1 vote134 views1 answer
How much every mysql database record takes from diskspace
SQL
1 vote190 views1 answer
Mysql is odd
SQL
0 vote179 views1 answer
SQL-Arten
SQL
0 vote135 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
4 votes189 views2 answers
Mysql alter table set column unique
SQL
1 vote128 views2 answers
Mysql trim whitespace
SQL