/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

7 votes402 views2 answers
3rd height salary sql
SQL
0 vote344 views1 answer
Select all same column value in sql
SQL
0 vote353 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
4 votes362 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote315 views1 answer
Mariadb used space
SQL
0 vote338 views1 answer
Systems sql
SQL
0 vote356 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote357 views1 answer
Mysql value ends with
SQL
0 vote342 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
3 votes297 views1 answer
System.debug apex
SQL