Update pg_tables, pg_index views to show tablespace name?

Started by Nonameover 21 years ago2 messages
#1Noname
spock@mgnet.de

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)

#2Robert Treat
xzilla@users.sourceforge.net
In reply to: Noname (#1)
Re: Update pg_tables, pg_index views to show tablespace name?

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