A. Kretschmer wrote: > am Wed, dem 01.11.2006, um 13:50:58 -0800 mailte Thomas Burns folgendes: > > Hi, > > > > I would like to use pg_dump to backup a list of tables to one file, > > but it looks like > > the -t option only supports one file. So, pg_dump gives you the > > option of backing > > up and entire database or one file, but nothing in between. Am I > > missing something? > > Is there a way to backup multiple tables (but not the whole database)? > > You can wait for 8.2, this version supports multiple -t - options. > Or you can concat several table-dumps to one big dump. Note that the latter option does not guarantee that you get a consistent dump. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
