/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

20 votes359 views3 answers
SQL query rename table
SQL
0 vote374 views1 answer
Mysql url data type
SQL
0 vote376 views1 answer
Reona
SQL
0 vote346 views1 answer
Install ms sql server management studio
SQL
0 vote398 views1 answer
Order child below the parent in mysqli
SQL
29 votes357 views6 answers
Delete all rows from table mysql
SQL
5 votes347 views1 answer
Oracle sysdate
SQL
0 vote358 views1 answer
Postgres reorder columns
SQL
16 votes389 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes367 views2 answers
Oracle unlock user
SQL