Thread: Show tablespace name in pg_tables and pg_indexes
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)
Attachment
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)
Attachment
On Mon, 12 Jul 2004, Klaus Naumann wrote: Hi, I've sent this patch a while ago - was it applied? Is something not ok with it? Don't want to bug anyone - just would like to have some feedback. Grettings, Klaus > 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)
[ Previous patch discarded.]
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews
and approves 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
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