Defindit Docs and Howto Home

This page last modified: Jun 30 2004
title:pgdump notes

# no reconnect
# data only
# force sign off? There is no -u
pg_dump -Ra <db>

-f <file>
--file=<file>

# create insert statements
pg_dump -d <db>
pg_dump --inserts <db>

# create inserts with column names
pg_dump -D <db>
pg_dump --column-inserts <db>
pg_dump --attribute-inserts <db>