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 vote403 views1 answer
Query for backup a database at another location in file system
SQL
1 vote399 views1 answer
Oracle show execution plan
SQL
0 vote289 views1 answer
Mysql collation for all languages
SQL
0 vote344 views1 answer
Sql server datetime to string
SQL
0 vote336 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote372 views1 answer
Load data infile mariadb slow
SQL
0 vote360 views1 answer
Sql insert query list of dictionaries
SQL
0 vote346 views2 answers
Sql join on comma separated field
SQL
0 vote356 views1 answer
Name '_mysql' is not defined
SQL
0 vote338 views2 answers
How to list all values of a column that start with a letter in sql
SQL