Postgres Pro
Downloads
Home   >   mailing lists

Re: sql to show tablespace for indexes - Mailing list pgsql-admin

From raghu ram
Subject Re: sql to show tablespace for indexes
Date
Msg-id d331f2ee0909141816o7fbf85aah87ebf7c0d1b578e1@mail.gmail.com
Whole thread Raw
In response to sql to show tablespace for indexes  (Kevin Kempter <kevink@consistentstate.com>)
List pgsql-admin
Tree view


On Fri, Sep 11, 2009 at 9:29 AM, Kevin Kempter <kevink@consistentstate.com> wrote:
Hi all;

How / where can I find which tablespace the indexes live in?



you can find which tablespace the indexes live in, by using below sql command:-

postgres=# select c.relname,t.spcname from pg_class c,pg_tablespace t where relkind='i' and c.reltablespace=t.oid ;


Regards
Raghu Ram

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: LDAP where DN does not include UID attribute
Next
From: Scott Marlowe
Date:
Subject: Re: LDAP where DN does not include UID attribute