find objects under a specific tablespace

From: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: find objects under a specific tablespace
Date: 2005-07-07 18:35:47
Message-ID: 42CD7603.1050506@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message BigSmoke 2005-07-07 19:28:23 A trigger that acts on a column with a given column name
Previous Message Clark Allan 2005-07-07 18:22:38 table name as variable within Function