Re: Show tablespace name in pg_tables and pg_indexes

Patch applied and catalog version updated.  We now have:

test=> select * from pg_tables;
     schemaname     |        tablename        | tablespace | tableowner | hasindexes | hasrules | hastriggers
--------------------+-------------------------+------------+------------+------------+----------+-------------
 information_schema | sql_packages            |            | postgres   | f          | f        | f
 information_schema | sql_sizing              |            | postgres   | f          | f        | f
 information_schema | sql_sizing_profiles     |            | postgres   | f          | f        | f
 information_schema | sql_features            |            | postgres   | f          | f        | f
 information_schema | sql_implementation_info |            | postgres   | f          | f        | f
 information_schema | sql_languages           |            | postgres   | f          | f        | f
 pg_catalog         | pg_shadow               | pg_global  | postgres   | t          | f        | t
 pg_catalog         | pg_opclass              |            | postgres   | t          | f        | f

These columns are individually selectable so if people don't want the
column they can just skip it.

---------------------------------------------------------------------------

Klaus Naumann wrote:
> On Mon, 12 Jul 2004, Klaus Naumann wrote:
>
> Hi,
>
> sorry, the last patch is buggy which didn't show up in the tests :(
> Two LEFTs were missing - new patch is attached.
>
> Greetings, Klaus
>
>
> >
> > Hi,
> >
> > the attached patch shows the new column "tablespace" in the mentioned
> > views.
> > Apply with
> >
> > ~/pgsql$ patch -p1 < 03_showtblspc.diff
> >
> > Greetings, Klaus
> >
> >
>
> --
> Full Name   : Klaus Naumann     | (http://www.mgnet.de/) (Germany)
> Phone / FAX : ++49/177/7862964  | E-Mail: (kn@mgnet.de)

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly

--
  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