On Thu, Oct 06, 2005 at 12:32:26PM -0700, David Fetter wrote: > On Thu, Oct 06, 2005 at 09:51:22AM -0400, Tom Lane wrote: > > WireSpot <wirespot@xxxxxxxxx> writes: > > > On 10/6/05, A. Kretschmer <akretschmer@xxxxxxxxxxxxx> wrote: > > >> You can use the -t more than once. > > >> > > >> pg_dump -U foobar database -t foo -t foo1 > > > > > Yes, pg_dump doesn't complain. But it only takes the first one > > > into consideration. I only get one table in the dump. > > > > Right. That's on the TODO list but not done yet :-(. > > There have been several patches against pg_dump to do both > multiple-table inclusion and multiple-table exclusion. These may get > into 8.2, as they missed 8.1. Looking at the archived discussion from the TODO (http://momjian.postgresql.org/cgi-bin/pgtodo?pg_dump), I find myself wondering if it would be good to allow for specifying a set of rules for what to dump in a file, probably something like a set of regexes with a way to specify if it's an include or exclude rule. Seems like it would be a heck of a lot simpler to do that for complex cases than deal with a pile of spaghetti on the command-line, but I've never really worried about it. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
