/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

1 vote137 views1 answer
Oracle plan hash value
SQL
1 vote102 views1 answer
Tsql random number
SQL
0 vote130 views1 answer
Typical max-connect-errors mysql
SQL
0 vote149 views1 answer
Mysql relationships between tables
SQL
0 vote125 views1 answer
Truncate a table then insert data
SQL
0 vote126 views1 answer
Create table with float datatype in sql server
SQL
0 vote119 views1 answer
Ajax error exception handeling
SQL
0 vote131 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote177 views1 answer
How to rename a database in tsql
SQL
7 votes126 views2 answers
Oracle sql drop index
SQL