Postgresql dump and restore db

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

Restore postgres database from sql file

psql -d database_name -f backup.sql

Source: stackoverflow.com

Similar codes

-1 vote169 views1 answer
How to use update trigger in sql
SQL
58 votes554 views4 answers
Mysql drop column
SQL
0 vote202 views1 answer
Download sql file of countries names
SQL
0 vote183 views1 answer
Vbscript connect mssql
SQL
0 vote179 views2 answers
Script all indexes in a database
SQL
0 vote214 views1 answer
Stop psql server windows
SQL
2 votes184 views1 answer
Mysql add boolean column
SQL
0 vote203 views1 answer
Sql max of two values
SQL
0 vote216 views1 answer
Sql convert float to string
SQL
-1 vote173 views1 answer
How to check table exists or not in postgresql
SQL