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 vote322 views1 answer
Age postgres
SQL
1 vote308 views1 answer
Top 10 rows in mysql
SQL
1 vote305 views1 answer
Count mysql server db tables
SQL
8 votes287 views1 answer
Sql remove characters from string right
SQL
0 vote315 views1 answer
Mysql match in serialized data
SQL
1 vote327 views1 answer
Mysql search like order by best match
SQL
17 votes328 views6 answers
Change column name in sql
SQL
0 vote357 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
9 votes289 views2 answers
Oracle all tables in schema
SQL
0 vote330 views1 answer
Postgresql find biggest table
SQL