Re: [GENERAL] find objects under a specific tablespace

2005-07-07 Thread Michael Fuhr
On Thu, Jul 07, 2005 at 02:35:47PM -0400, Ying Lu wrote: > > I'd like to know how to check whether a specific object is created under > a specific *tablespace*? How to find all objects under a specific > tablespace? See pg_tablespace and pg_class.reltablespace in the "System Catalogs" chapter o

[GENERAL] find objects under a specific tablespace

2005-07-07 Thread Ying Lu
Greetings, I'd like to know how to check whether a specific object is created under a specific *tablespace*? How to find all objects under a specific tablespace? For example, one index named "idx_test1" has been created. Now I'd like to check which tablespace does this index belong to? Tha