/SQL/Restore postgres database from sql file

Restore postgres database from sql file

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

3 votes344 views1 answer
Increment integer in table sql
SQL
22 votes320 views3 answers
Join three tables sql
SQL
2 votes322 views1 answer
Date conversion in mysql column
SQL
0 vote313 views1 answer
How to print out column name differently in mysql
SQL
10 votes325 views2 answers
Show tables in schema oracle
SQL
0 vote310 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote351 views2 answers
Compound operator in sql
SQL
0 vote342 views1 answer
Shrink database file in sql server
SQL
0 vote309 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
16 votes344 views2 answers
Mysql date between two dates
SQL