Re: find objects stored on a specific tablespace

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wed, Jul 18, 2018 at 10:06 AM, Ghiurea, Isabella <Isabella.Ghiurea@xxxxxxxxxxxxxx> 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.