Possible to export a database from PostgreSQL onto your computer hard drive

Question

Is it possible for me to export a database that i have created from PostgreSQL onto my hard drive.

Thank you.

digitaljoel · Accepted Answer · 2012-01-16 20:47:48Z

3

you can use pg_dump and it's various options on the command line to get it in a format you like.

answered Jan 16, 2012 at 20:47

digitaljoel

26.6k15 gold badges94 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

If on windows, then yes, it can be the windows command prompt.

nilgun · Accepted Answer · 2012-01-16 21:18:31Z

2

You can right click on the database and click "Backup" using pgAdmin.

answered Jan 16, 2012 at 20:39

nilgun

10.6k4 gold badges48 silver badges57 bronze badges