From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andreas Joseph Krogh <andreak@officenet.no>
Cc: pgsql-sql@postgresql.org
Subject: Re: Backup of multiple tables
Date: Fri, 19 Sep 2003 11:38:17 -0400
Message-ID: <20380.1063985897@sss.pgh.pa.us> (raw)
In-Reply-To: <200309191354.06071.andreak@officenet.no>
References: <200309191354.06071.andreak@officenet.no>
Andreas Joseph Krogh <andreak@officenet.no> writes:
> I usually backup my database with pg_backup without the -t option. But now I
> need to only backup certain tables(say tab1 and tab2), is this possible with
> pg_dump? I've tried with "pg_dump -t tab1 -t tab2" without success.
pg_dump can only handle one -t option at a time. It'd make sense to
allow multiple -t options (likewise -n) but no one's got round to
improving the code in that particular direction. I don't think it would
be hard; want to fix it and send in a patch?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, andreak@officenet.no
Subject: Re: Backup of multiple tables
In-Reply-To: <20380.1063985897@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox