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
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