On Fri, Sep 11, 2009 at 9:29 AM, Kevin Kempter <kev...@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
