Search Postgresql Archives

Re: fine tuned database dump/reload?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux