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 vote158 views1 answer
Oracle table free space
SQL
1 vote191 views1 answer
Homebrew install mysql
SQL
0 vote171 views1 answer
Sql mod even odd
SQL
10 votes140 views4 answers
Join with multiple conditions sql
SQL
0 vote164 views2 answers
Compound operator in sql
SQL
0 vote146 views1 answer
Mysql workbench view
SQL
0 vote159 views1 answer
Get schema of table sql
SQL
0 vote164 views1 answer
Extract sql from query object sqlalchemy
SQL
3 votes184 views2 answers
How to open postgresql in windows
SQL
0 vote152 views1 answer
Pip install mysqlclient error
SQL