/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

5 votes206 views1 answer
Oracle create table comment
SQL
0 vote218 views1 answer
Sparql if bound query
SQL
-1 vote199 views1 answer
Concat two columns in sql server
SQL
5 votes221 views1 answer
Ascending order and where in sql
SQL
0 vote191 views1 answer
How to add timestamp column in mysql
SQL
1 vote186 views1 answer
Base nosql
SQL
0 vote229 views1 answer
Reset postgresql password windows
SQL
0 vote227 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote174 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote275 views1 answer
Modificar tipo de dato sql server
SQL