am 06.10.2005, um 13:59:44 +0300 mailte WireSpot folgendes: > Is it possible to dump an entire database but to skip one or two tables? Or, > conversely, to restore an entire dump except for one or two tables? > (Although I'd prefer the first version.) > > The only related option for both pg_dump and pg_restore is --table, which > only takes 1 (one) table name. If only it accepted more than one I could've > found a workaround. You can use the -t more than once. pg_dump -U foobar database -t foo -t foo1 > I'm considering doing a dump with --table for each table except the one or > two in question. But I wonder, if I simply concatenate the resulting SQL > dumps, will I get a valid dump? There are all kinds of foreign key I'm not sure, perhaps if you dump with --data-only every table. > contraints in place, and if the table data is not fed back in the right > order it's useless. Right. You can do a dump from all tables and after restore all the tables you can delete the one or two tables. Other way: pg_restore with '--use-list=list-file'. You can create a list of contents of the archive and edit this list. (pg_restore --list) Regards, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
