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 vote221 views1 answer
Sql server inner join convert collation
SQL
0 vote257 views2 answers
Oracle chain rules
SQL
4 votes246 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
1 vote239 views1 answer
Cross schema query oracle 2 users
SQL
0 vote232 views1 answer
Sql query to get column names and data types in sql server
SQL
1 vote213 views1 answer
Sql drop with dependencies
SQL
2 votes229 views3 answers
Row number mssql
SQL
3 votes253 views1 answer
How to add unique constraint in mysql table
SQL
3 votes255 views2 answers
@sqlresultsetmapping
SQL
0 vote225 views1 answer
Grant privileges mysql to database 1064
SQL