/SQL/How to take database dump in postgresql

How to take database dump in postgresql

pg_dump dbname > outfile

Postgres make sql dump

pg_dump -U username dbname > dbexport.pgsql

Source: a2hosting.in

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

Psql load dump

psql databasename < data_base_dump

Source: stackoverflow.com

Similar codes

8 votes71 views1 answer
Similarities between ddl and dml
SQL
3 votes75 views1 answer
How to get list of synonyms in oracle
SQL
1 vote128 views3 answers
Mysql parse int
SQL
0 vote121 views1 answer
Oracle list partitions
SQL
0 vote120 views3 answers
Database restoring error
SQL
0 vote108 views1 answer
Mql5 datetime get hour
SQL
0 vote120 views1 answer
How to get data from 2 database
SQL
4 votes105 views1 answer
What are the data types in sql
SQL
0 vote126 views1 answer
Mysql sql.gz
SQL
0 vote104 views1 answer
Oracle list of long running queries
SQL