| From: | "Alexander M(dot) Pravking" <fduch(at)antar(dot)bryansk(dot)ru> |
|---|---|
| To: | Andreas Joseph Krogh <andreak(at)officenet(dot)no> |
| Cc: | "pgsql-sql (at) postgresql (dot) org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Backup of multiple tables |
| Date: | 2003-09-19 14:19:17 |
| Message-ID: | 20030919141917.GA71229@dyatel.antar.bryansk.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| dump.pl | application/x-perl | 2.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander M. Pravking | 2003-09-19 14:50:32 | Re: Backup of multiple tables |
| Previous Message | Richard Sydney-Smith | 2003-09-19 14:09:56 | restoring dbschema |