Re: [ADMIN] sql to show tablespace for indexes

2009-09-14 Thread raghu ram
On Fri, Sep 11, 2009 at 9:29 AM, Kevin Kempter 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 relkin

[ADMIN] sql to show tablespace for indexes

2009-09-10 Thread Kevin Kempter
Hi all; How / where can I find which tablespace the indexes live in? Thanks in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin