We are thinking of adding a per-schema dump option in 7.4. Would that help?
--------------------------------------------------------------------------- Vitaliy Fuks wrote: > Hello, > > Could there potentially be an option in addition to -t "table_name", to > either: > > a) Examine all relationships and dump all dependant objects > b) Dump only table named "table_name" > > One can argue that when asking for "a" table one really only wants that > table information, and nothing else. Some people of course can argue > that just a table by itself may not be usable by itself in some > situations - so that's why the option described above could cater both > situations. > > I wish I could just give you a patch but there are probably people who > know pg_dump internals who could produce such patch in 10x less amount > of time. > > --Vitaliy > > --- Tom Lane <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] writes: > > > pg_dump examines all tables even with -t "table_name" speficied > > > > 7.3 is a little better. It's not that easy to determine in advance > > what > > information is needed, though; consider inheritance for example. > > > > regards, tom lane > > > __________________________________________________ > Do you Yahoo!? > HotJobs - Search new jobs daily now > http://hotjobs.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html