Обсуждение: sql to show tablespace for indexes

Hi all;

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

Thanks in advance

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


Regards
Raghu Ram