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 vote279 views1 answer
Postgres select as csv
SQL
0 vote190 views1 answer
SQL server select to get sum of hours
SQL
0 vote224 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote195 views1 answer
Change default schema sql server
SQL
1 vote198 views1 answer
Sql delete all values in a column
SQL
0 vote218 views1 answer
How to move a column to different spot mysql
SQL
0 vote293 views1 answer
How to find sql server name
SQL
0 vote286 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote187 views1 answer
Check if a word appears at the end sql query
SQL
0 vote216 views2 answers
Which MySQL statement is used to delete data from a database
SQL