Re: Bug #805: pg_dump examines all tables even with -t "table_name" speficied - Mailing list pgsql-bugs

From Vitaliy Fuks
Subject Re: Bug #805: pg_dump examines all tables even with -t "table_name" speficied
Date
Msg-id 20021029191315.4807.qmail@web13508.mail.yahoo.com
Whole thread Raw
In response to Re: Bug #805: pg_dump examines all tables even with -t "table_name" speficied  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bug #805: pg_dump examines all tables even with -t "table_name"
List pgsql-bugs
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/

pgsql-bugs by date:

Previous
From: Shibashish
Date:
Subject: PostgreSQL Installation on SCO
Next
From: "Ban"
Date:
Subject: /tmp/.s.PGSQL.5432.lock: Permission denied