Last Updated: February 25, 2016
·
411
· nicolaslazartekaqui

Postgres - How to dump a database

#psql

Dump a single database:

$ pg_dump -U username dbname -f dumpfile.sql

Dump all databases:

$ pg_dumpall -U username > dumpfile.sql
#psql

Written by Nícolas Lazarte Kaqui

Say Thanks
Respond

Related protips

Postgres Expanded Display

8.799K
0

Exporting Postgres queries as JSON

4.74K
0

Prettify records with long columns in PostgreSQL shell

1.841K
0

Have a fresh tip? Share with Coderwall community!

Post
Post a tip
Best #Psql Authors
jasdeepsingh
8.793K
#psql
#JavaScript
#Objective-C
stuartc
4.74K
#psql
#ruby
#rails
creaktive
1.841K
#psql
#Perl
#C
ashmckenzie
1.839K
#psql
#JavaScript
#ruby
nicolaslazartekaqui
1.339K
#psql
#javascript
#ruby
Related Tags
#psql
Sponsored by
#native_company#
#native_desc#
#native_cta#
Awesome Job
See All Jobs
Post a job for only $299
Thanks to our sponsor
Sponsored by #native_company# — Learn More
#native_title# #native_desc#
#native_cta#