Re: Bug #805: pg_dump examines all tables even with -t "table_name"

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > pgsql-bugs(at)postgresql(dot)org 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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073