Re: [SQL] Backup of multiple tables

2003-09-22 Thread Bertrand Petit
On Tue, Sep 23, 2003 at 12:34:00AM +0200, Andreas Joseph Krogh wrote: > > 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. If you acheive to add the selection of tables to dump, you may at the same time try to add a simila

Re: [SQL] Backup of multiple tables

2003-09-22 Thread Dan Langille
On 23 Sep 2003 at 0:34, Andreas Joseph Krogh wrote: > On Friday 19 September 2003 17:38, Tom Lane wrote: > > > 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 direct

Re: [SQL] Backup of multiple tables

2003-09-22 Thread Andreas Joseph Krogh
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 19 September 2003 17:38, Tom Lane wrote: > Andreas Joseph Krogh <[EMAIL PROTECTED]> 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 >

Re: [SQL] Backup of multiple tables

2003-09-19 Thread Tom Lane
Andreas Joseph Krogh <[EMAIL PROTECTED]> 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 ha

Re: [SQL] Backup of multiple tables

2003-09-19 Thread Alexander M. Pravking
On Fri, Sep 19, 2003 at 04:30:57PM +0200, Andreas Joseph Krogh wrote: > > Here's a perl script I used to dump all the tables separately. > > I'm not sure most of options do work there, I didn't test ;-) > > It won't be hard to make it dump certain tables, I think. > > Thanks for your suggestion, b

Re: [SQL] Backup of multiple tables

2003-09-19 Thread Alexander M. Pravking
On Fri, Sep 19, 2003 at 01:54:01PM +0200, Andreas Joseph Krogh wrote: > 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.

[SQL] Backup of multiple tables

2003-09-19 Thread Andreas Joseph Krogh
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi. 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. - -- Andreas Joseph K