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