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

From Alexander M. Pravking
Subject Re: Backup of multiple tables
Date
Msg-id 20030919141917.GA71229@dyatel.antar.bryansk.ru
Whole thread Raw
In response to Backup of multiple tables  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-sql
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.

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.


--
Fduch M. Pravking

Attachment

pgsql-sql by date:

Previous
From: "Richard Sydney-Smith"
Date:
Subject: restoring dbschema
Next
From: "Alexander M. Pravking"
Date:
Subject: Re: Backup of multiple tables