Exporting data of postgresql database with pg_dump

pg_dump — extract a PostgreSQL database into a script file or other archive file.


E:\postgre\bin>pg_dump -U postgres -h localhost data2 > db.sql


after executing first line, the system only asks for password of the user and the dump file will be created.

Where :
pg_dump : is the dump executable, found under bin directory of postgres installation
-U : Username
-h : localhost
data2 : name of the database to be exported
db.sql : name of the export file


You may also like...