/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 vote161 views1 answer
On sql table data exists
SQL
1 vote162 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
2 votes154 views1 answer
Set boolean flasksql
SQL
0 vote146 views1 answer
Show specific events on mysql
SQL
1 vote196 views1 answer
Oracle apex version view
SQL
11 votes173 views1 answer
Ddl view
SQL
1 vote208 views3 answers
Date_add mysql
SQL
0 vote180 views1 answer
Codigo crear tablas sql server
SQL
4 votes178 views1 answer
Mysql set max connections
SQL
0 vote166 views1 answer
Postgresql linux password
SQL