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 vote126 views1 answer
How to truncate a table in databse
SQL
-1 vote120 views2 answers
Postgresql get last 10 records
SQL
0 vote127 views1 answer
Window function to forward fill
SQL
0 vote125 views2 answers
Oracle select
SQL
0 vote117 views1 answer
Connexion mysql
SQL
0 vote116 views1 answer
1 column values in to 1 single row in sql
SQL
7 votes117 views1 answer
Safe update mysql
SQL
2 votes108 views1 answer
Sqlite3 show columns name
SQL
12 votes177 views4 answers
How to drop all tables in postgresql
SQL
0 vote129 views1 answer
Mysql grouping functions
SQL