Re: dumping strategy - Mailing list pgsql-general

From newsreader@mediaone.net
Subject Re: dumping strategy
Date
Msg-id 20010530151939.A12164@dragon.universe
Whole thread Raw
In response to Re: dumping strategy  ("Mitch Vincent" <mvincent@cablespeed.com>)
List pgsql-general
On Wed, May 30, 2001 at 02:59:16PM -0400, Mitch Vincent wrote:
> Why wouldn't pg_dump work? You can do pg_dump -t <tablename> <databasename>
> to dump just a single table.... If pg_dump fails for some reason, I'd say
> the developers would like to know as I'm sure it's not supposed to :-)
>
> Good luck!
>
> -Mitch
> >

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

pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: dumping strategy
Next
From: "Tim Barnard"
Date:
Subject: Re: [SQL] Difficult SQL Statement