Postgres Pro
Downloads
Home   >   mailing lists

find objects under a specific tablespace - Mailing list pgsql-general

From Ying Lu
Subject find objects under a specific tablespace
Date
Msg-id 42CD7603.1050506@cs.concordia.ca
Whole thread Raw
Responses Re: find objects under a specific tablespace
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Clark Allan
Date:
Subject: table name as variable within Function
Next
From: BigSmoke
Date:
Subject: A trigger that acts on a column with a given column name