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 vote175 views1 answer
Mysql change timestamp on update
SQL
2 votes160 views2 answers
Function in sql
SQL
0 vote179 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote197 views1 answer
Login failed for user sql server
SQL
0 vote196 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote161 views1 answer
MySQL INSERT IGNORE Statement
SQL
3 votes164 views1 answer
Oracle list user grants
SQL
3 votes205 views1 answer
Mysql cli connect with password
SQL
9 votes202 views3 answers
Sequence postgresql
SQL
1 vote167 views1 answer
How to get the date diff on once field in sql server
SQL