Postgresql dump and restore db

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

1 vote327 views1 answer
Show all event schedular on mysql
SQL
0 vote351 views1 answer
Oracle to_number
SQL
0 vote345 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
1 vote342 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote276 views1 answer
Oracle function select into
SQL
0 vote280 views1 answer
Kannst du deine finger trainieren
SQL
6 votes325 views5 answers
Alter table oracle
SQL
0 vote316 views1 answer
Check duplicate values plsql
SQL
2 votes317 views3 answers
3 days back in sql server
SQL
4 votes317 views3 answers
Oracle sql first day of quarter
SQL