Re: Backup of multiple tables - Mailing list pgsql-sql

From Andreas Joseph Krogh
Subject Re: Backup of multiple tables
Date
Msg-id 200309230034.06215.andreak@officenet.no
Whole thread Raw
In response to Re: Backup of multiple tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Backup of multiple tables  ("Dan Langille" <dan@langille.org>)
Re: Backup of multiple tables  (Bertrand Petit <pgsql-sql@phoe.frmug.org>)
List pgsql-sql
-----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-----


pgsql-sql by date:

Previous
From: "Andrew J. Kopciuch"
Date:
Subject: Re: GiST and full text search
Next
From: "Dan Langille"
Date:
Subject: Re: Backup of multiple tables