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

0 vote276 views2 answers
Mysql updating multiple column values from array variable
SQL
36 votes309 views3 answers
Add column in mysq
SQL
0 vote300 views1 answer
Materialized view redshift
SQL
11 votes288 views2 answers
Turn off safe mode mysql
SQL
3 votes294 views1 answer
How to find names includes in sql
SQL
2 votes317 views1 answer
Select a certain number of entries from select mysql
SQL
3 votes285 views2 answers
Brew start mysql
SQL
0 vote283 views1 answer
How to create a table in sql stack overflow
SQL
0 vote281 views2 answers
Sql use not in
SQL
1 vote294 views1 answer
Rows to comma separated values in mssql
SQL