From: Andreas Joseph Krogh <andreak@officenet.no>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Backup of multiple tables
Date: Tue, 23 Sep 2003 00:34:00 +0200
Message-ID: <200309230034.06215.andreak@officenet.no> (raw)
In-Reply-To: <20380.1063985897@sss.pgh.pa.us>
References: <200309191354.06071.andreak@officenet.no>
<20380.1063985897@sss.pgh.pa.us>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Friday 19 September 2003 17:38, Tom Lane wrote:
> 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?
I've never looked at the code-base of pgsql before, but I'll give it a try.
Don't expect anything real soon tho.
- --
Andreas Joseph Krogh <andreak@officenet.no>
Managing Director, Senior Software Developer
OfficeNet AS
- - Writing software is more fun than working.
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQE/b3jeUopImDh2gfQRAhP3AKCwsviN37+7ZAG4x4hI/ErQEyKmHACfW4on
EI900FlO/lDInoDnf9nDEM0=
=Xcq/
-----END PGP SIGNATURE-----
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: andreak@officenet.no, tgl@sss.pgh.pa.us
Subject: Re: Backup of multiple tables
In-Reply-To: <200309230034.06215.andreak@officenet.no>
* 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