Postgres Pro
Downloads
Home   >   mailing lists

Thread: find objects stored on a specific tablespace

find objects stored on a specific tablespace

From
"Ghiurea, Isabella"
Date:

Hi Gurus

I am looking to drop  a  user tablespace  I need to find and confirm if there are any and which  tables+indexers  still using this  tablespace, what pg view and statement will give me this information?


thank you

Isabella

Re: find objects stored on a specific tablespace

From
"David G. Johnston"
Date:
On Wed, Jul 18, 2018 at 10:06 AM, Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca> wrote:

Hi Gurus

I am looking to drop  a  user tablespace  I need to find and confirm if there are any and which  tables+indexers  still using this  tablespace, what pg view and statement will give me this information?

"pg_class.​​reltablespace" linking to "pg_tablespace"

David J.