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 vote218 views1 answer
Set statistics on in ssms
SQL
0 vote237 views1 answer
Insert or update sql query
SQL
0 vote239 views1 answer
Sqlalchemy empty table
SQL
0 vote221 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
1 vote252 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote237 views1 answer
How to run mysql on terminal mac
SQL
0 vote223 views1 answer
Mysql query to add hours to column in table
SQL
-1 vote239 views1 answer
Minus vs except in sql
SQL
2 votes219 views3 answers
3 days back in sql server
SQL
14 votes247 views4 answers
Import database through command line
SQL