Re: fine tuned database dump/reload? - Mailing list pgsql-general

From Doug Bloebaum
Subject Re: fine tuned database dump/reload?
Date
Msg-id caa2de8a0510111137p5331d33ek544bd3e7a79fd27a@mail.gmail.com
Whole thread Raw
In response to Re: fine tuned database dump/reload?  (Bricklen Anderson <BAnderson@PresiNET.com>)
List pgsql-general
On 10/11/05, Dan Armbrust wrote::
> Now I'm just filling the mailing list with mis-information.  It actually
> ignores all but the last -t flag - so this only allows me to specify one
> table at a time, rather than several tables.

There's always the low-tech option of:

for table in `cat /tmp/table_list.txt`
do
  pg_dump -t $table my_db >> /tmp/my_tables.dmp
done 

It's far from elegant, but it does allow you to dump a specific list of tables.

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: exceptions
Next
From: Neil Conway
Date:
Subject: Re: PostgreSQL's bug tracker