Re: Best pg_dump practices - Mailing list pgsql-general

From Dmitri Bichko
Subject Re: Best pg_dump practices
Date
Msg-id 7A4ADADFC8AFF0478D47F63BEDD57CE30CDFA4@gpmail.gphq.genpathpharma.com
Whole thread Raw
In response to Best pg_dump practices  (MT <m_tessier@sympatico.ca>)
Responses Re: Best pg_dump practices
List pgsql-general
> pg_dump -c -f dumpfile.sql dbname

> This will give me the data in its original, pristine form. Note that
using pg_dump this way means that the data gets
> dumped as copy too. Is there a way to dump only the db objects (ie.
tables, sequences, etc) and exclude the data.

The -s (--schema-only) flag dumps only the schema, not the data... At
least according to pg_dump --help

Dmitri

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Next
From: Ernest E Vogelsinger
Date:
Subject: Query planner question