find objects under a specific tablespace

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

find objects under a specific tablespace

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?

Thanks a lot,
Emi

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: find objects under a specific tablespace

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 of the documentation:

http://www.postgresql.org/docs/8.0/static/catalog-pg-tablespace.html
http://www.postgresql.org/docs/8.0/static/catalog-pg-class.html

> For example, one index named "idx_test1" has been created. Now I'd like
> to check which tablespace does this index belong to?

Aside from querying the system catalogs, you could use "\d idx_test1"
in psql -- that should show the index's tablespace.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq