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

5 votes129 views1 answer
List foreign key oracle
SQL
0 vote150 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote210 views1 answer
Mysql disable triggers
SQL
6 votes141 views2 answers
Postgresql restore from dump
SQL
0 vote143 views1 answer
How to add timestamp column in mysql
SQL
3 votes184 views1 answer
How to get yesterday date in sql
SQL
0 vote151 views1 answer
Remove transient options sql wordpress
SQL
0 vote134 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote146 views1 answer
How to select even id in sql
SQL
0 vote90 views1 answer
Mysql convert column to uppercase
SQL