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

0 vote143 views1 answer
Oracle merge insert if not exists
SQL
0 vote133 views1 answer
Get who is hired in specific month in sql
SQL
0 vote162 views1 answer
Postgres list users and roles
SQL
0 vote135 views2 answers
Get all index postgres
SQL
0 vote102 views2 answers
Spring properties file for db
SQL
0 vote151 views1 answer
Oracle lower in where clause
SQL
0 vote165 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
1 vote154 views1 answer
How to put value in variable mysql
SQL
20 votes146 views1 answer
Sql change column types
SQL
4 votes136 views1 answer
Oracle error line
SQL