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