Thread: Update pg_tables, pg_index views to show tablespace name?

Update pg_tables, pg_index views to show tablespace name?

From
spock@mgnet.de
Date:
Hi,

while playing around with the tablespace stuff I noticed that on can't see
the tablespace a table is in when querying the pg_tables view.
I think the tablespace a table is in is a valuable information and should
be shown there. This also applies to any ohter related view (like
pg_indexes etc.).
I'll try to make a patch if you'd agree that this information is
"missing".

Greetings, Klaus

-- 
Full Name   : Klaus Naumann     | (http://www.mgnet.de/) (Germany)
Phone / FAX : ++49/177/7862964  | E-Mail: (kn@mgnet.de)


Re: Update pg_tables, pg_index views to show tablespace name?

From
Robert Treat
Date:
On Wednesday 07 July 2004 08:21, spock@mgnet.de wrote:
> Hi,
>
> while playing around with the tablespace stuff I noticed that on can't see
> the tablespace a table is in when querying the pg_tables view.
> I think the tablespace a table is in is a valuable information and should
> be shown there. This also applies to any ohter related view (like
> pg_indexes etc.).
> I'll try to make a patch if you'd agree that this information is
> "missing".
>

ISTM this would be a good idea.

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL