/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

0 vote232 views2 answers
Homebrew nysql launch
SQL
0 vote236 views1 answer
Change date format in oracle query
SQL
17 votes255 views2 answers
T_sql contains
SQL
5 votes218 views1 answer
JBDC
SQL
0 vote199 views1 answer
How to get inserted id in sql server
SQL
5 votes200 views6 answers
Sql add days to date
SQL
4 votes227 views4 answers
Pl sql output
SQL
1 vote218 views1 answer
Sql server get users
SQL
14 votes230 views3 answers
Alter foreign key
SQL
0 vote209 views2 answers
How to save result of sqlite query in a table
SQL