/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 vote218 views1 answer
Ms sql print more than 1 variable
SQL
0 vote200 views2 answers
How to drop mili second in sql
SQL
0 vote214 views1 answer
Postgresql on conflict pair
SQL
13 votes170 views2 answers
Check if value is null mysql
SQL
1 vote177 views1 answer
Sql delete all values in a column
SQL
0 vote206 views2 answers
Sql if empty then
SQL
0 vote183 views1 answer
Convert sql server guid to varbinary
SQL
1 vote171 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote179 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote232 views1 answer
Mysql wsrep ls
SQL