Re: sql to show tablespace for indexes

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: Kevin Kempter <kevink(at)consistentstate(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: sql to show tablespace for indexes
Date: 2009-09-15 01:16:13
Message-ID: d331f2ee0909141816o7fbf85aah87ebf7c0d1b578e1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Sep 11, 2009 at 9:29 AM, Kevin Kempter
<kevink(at)consistentstate(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-09-15 07:35:30 Re: LDAP where DN does not include UID attribute
Previous Message Robert Fleming 2009-09-15 00:23:44 Re: LDAP where DN does not include UID attribute