/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 vote274 views1 answer
T-sql check if data exists
SQL
1 vote281 views1 answer
Sql padd let with zeros
SQL
0 vote298 views1 answer
Oracle sql copy table without data
SQL
0 vote276 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
10 votes256 views2 answers
Mysql select timestamp group by day
SQL
0 vote283 views1 answer
Search In the Database using Text
SQL
0 vote263 views1 answer
Postgresql add not null and not empty constraint
SQL
5 votes266 views2 answers
Oracle show procedures
SQL
-1 vote340 views5 answers
Left join sql
SQL
1 vote286 views1 answer
Size of all tables in a schema oracle
SQL