From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Klaus Naumann <kn(at)mgnet(dot)de> |
Cc: | PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: Show tablespace name in pg_tables and pg_indexes |
Date: | 2004-07-21 16:51:50 |
Message-ID: | 200407211651.i6LGpou02408@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
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(at)mgnet(dot)de)
Content-Description:
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-07-21 17:34:16 | Re: logfile subprocess and Fancy File Functions |
Previous Message | Tom Lane | 2004-07-21 15:09:17 | Re: Patch for pg_dump: Multiple -t options and new -T option |