/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 vote203 views1 answer
Get last inserted primary key
SQL
0 vote142 views1 answer
Oracle current session details
SQL
1 vote145 views2 answers
How to search date in sql query
SQL
0 vote156 views2 answers
Enter into postgresql database,create user and grant Access
SQL
7 votes139 views2 answers
Mysql db size
SQL
1 vote136 views6 answers
In sql
SQL
4 votes118 views1 answer
Sql list users and roles
SQL
2 votes133 views1 answer
Mysql sysdate
SQL
1 vote164 views1 answer
How to show index type in postgresql
SQL
14 votes143 views1 answer
Sql value of string
SQL