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

1 vote105 views1 answer
Mysql remove last empty newline
SQL
1 vote111 views1 answer
How to get alternate records from a table in sql
SQL
1 vote109 views1 answer
Add many column to sap iq table
SQL
1 vote99 views1 answer
Show table columns
SQL
0 vote111 views1 answer
Sql server sleep
SQL
2 votes96 views1 answer
Mysql trigger after update
SQL
0 vote62 views1 answer
Mysql insert with foreign key
SQL
1 vote100 views1 answer
Oracle db create new schema
SQL
0 vote88 views1 answer
Oracle list chain steps
SQL
0 vote107 views1 answer
Min varias colunas spark sql
SQL