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

1 vote172 views1 answer
Sql select all from one table and one column from another
SQL
36 votes297 views6 answers
Change column data type sql
SQL
11 votes199 views1 answer
Oracle export view ddl
SQL
0 vote166 views1 answer
Postrgres trunc
SQL
0 vote178 views1 answer
How to get inserted id in sql server
SQL
0 vote199 views1 answer
SQL Server date literal
SQL
0 vote179 views4 answers
Mysql on kubernetes
SQL
0 vote190 views3 answers
Sql delete all except
SQL
0 vote174 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote218 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL