Обсуждение: Update pg_tables, pg_index views to show tablespace name?
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)
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