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 vote99 views1 answer
Pl/sql loop example
SQL
0 vote120 views1 answer
Load data infile mariadb slow
SQL
12 votes102 views4 answers
Mysql version query
SQL
0 vote94 views1 answer
Check duplicate values plsql
SQL
0 vote158 views1 answer
How to find the most occuring in SQL
SQL
0 vote56 views1 answer
'0000-00-00' for column '
SQL
0 vote98 views1 answer
Mysql remove tabs from string
SQL
0 vote104 views1 answer
Oracle sql generate list of days
SQL
57 votes258 views5 answers
How to create a new user in postgresql
SQL
0 vote110 views1 answer
How to map sql column to custom names
SQL