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 vote176 views1 answer
Full syntax inner join
SQL
31 votes201 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote196 views2 answers
How to use aggregate functions in sql
SQL
0 vote202 views1 answer
Sql server separar numeros por comas miles
SQL
6 votes149 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote185 views1 answer
Check psql validity function
SQL
16 votes207 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote263 views1 answer
Oracle current date minus 1 day
SQL
0 vote194 views1 answer
Oracle get running queries
SQL
0 vote218 views1 answer
Flask sqlalchemy session delete
SQL