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 vote178 views1 answer
Psql check if sql script is valid
SQL
0 vote235 views1 answer
Alter database name script
SQL
1 vote198 views1 answer
Mysql select all and rename one
SQL
1 vote170 views1 answer
Mysql select utc time in eastern time
SQL
0 vote176 views1 answer
Postgresql not in alternative
SQL
0 vote177 views1 answer
Mysql database hyphen
SQL
1 vote229 views1 answer
Postgres set sequence value to max id
SQL
0 vote176 views1 answer
H2 auto increment and unique
SQL
2 votes183 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote177 views1 answer
Sql orcale i forgot what my name & password was
SQL