/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 votes45 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote46 views1 answer
Soql more than today
SQL
0 vote50 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote88 views1 answer
Dublicate row sql
SQL
0 vote46 views3 answers
Postgres date difference seconds
SQL
0 vote48 views1 answer
Get cpu details sql
SQL
4 votes47 views2 answers
Oracle unlock user
SQL
0 vote48 views1 answer
How to check replication lag in mySQL
SQL
20 votes57 views4 answers
Sql count if
SQL
1 vote53 views1 answer
Oracle grant on all tables in schema
SQL