Re: dumping strategy - Mailing list pgsql-general

From Richard Huxton
Subject Re: dumping strategy
Date
Msg-id 007201c0e9bf$6cd99cc0$1001a8c0@archonet.com
Whole thread Raw
In response to dumping strategy  (newsreader@mediaone.net)
Responses Re: dumping strategy  (newsreader@mediaone.net)
Re: dumping strategy  (Neil Conway <nconway@klamath.dyndns.org>)
List pgsql-general
From: <newsreader@mediaone.net>

> Sorry for the confusion.
>
> pg_dump works but I have to write
> a shell script to dump each individual tables.
>
> What I meant by it does not work is like this
>
> pg_dump -t table1 table2 table3 database |bzip2 > database.du

It's just

for i in t1 t2 t3; do pg_dump -t$i mydb > $i.tbl; done


- Richard Huxton


pgsql-general by date:

Previous
From: Alexey Borzov
Date:
Subject: Postgres docs in .chm format --- is this possible?
Next
From: newsreader@mediaone.net
Date:
Subject: Re: dumping strategy