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

4 votes339 views2 answers
Delete all table oracle
SQL
0 vote276 views1 answer
Laravel migration sql dump
SQL
0 vote271 views1 answer
Mysql make date from 2 column
SQL
0 vote261 views1 answer
Import sql inside hide sql
SQL
0 vote255 views1 answer
Mysql workbench procedure
SQL
0 vote264 views1 answer
Select all tables linked server sql
SQL
0 vote255 views1 answer
Find wordpress version in database
SQL
0 vote276 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote255 views1 answer
Call function in query sql server
SQL
0 vote260 views1 answer
Sql get guid
SQL