Re: Best pg_dump practices

From: "Dmitri Bichko" <dbichko(at)genpathpharma(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Best pg_dump practices
Date: 2003-06-12 21:24:40
Message-ID: 7A4ADADFC8AFF0478D47F63BEDD57CE30CDFA4@gpmail.gphq.genpathpharma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ernest E Vogelsinger 2003-06-12 21:37:47 Query planner question
Previous Message Jim C. Nasby 2003-06-12 20:57:55 Re: [HACKERS] SAP and MySQL ... [and Benchmark]