| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump question |
| Date: | 2006-11-02 15:56:08 |
| Message-ID: | 20061102155608.GE25444@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
A. Kretschmer wrote:
> am Wed, dem 01.11.2006, um 13:50:58 -0800 mailte Thomas Burns folgendes:
> > Hi,
> >
> > I would like to use pg_dump to backup a list of tables to one file,
> > but it looks like
> > the -t option only supports one file. So, pg_dump gives you the
> > option of backing
> > up and entire database or one file, but nothing in between. Am I
> > missing something?
> > Is there a way to backup multiple tables (but not the whole database)?
>
> You can wait for 8.2, this version supports multiple -t - options.
> Or you can concat several table-dumps to one big dump.
Note that the latter option does not guarantee that you get a consistent
dump.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shelby Cain | 2006-11-02 16:00:19 | Re: lots of values for IN() clause |
| Previous Message | Markus Schiltknecht | 2006-11-02 15:55:08 | Re: lots of values for IN() clause |