Re: dumping strategy

From: "Richard Huxton" <dev(at)archonet(dot)com>
To: <newsreader(at)mediaone(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: dumping strategy
Date: 2001-05-31 10:49:48
Message-ID: 007201c0e9bf$6cd99cc0$1001a8c0@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: <newsreader(at)mediaone(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message newsreader 2001-05-31 12:07:00 Re: dumping strategy
Previous Message Alexey Borzov 2001-05-31 09:12:07 Postgres docs in .chm format --- is this possible?