pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedfind objects stored on a specific tablespace
2+ messages / 2 participants
[nested] [flat]
* find objects stored on a specific tablespace
@ 2018-07-18 17:06 Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca>
2018-07-18 17:10 ` Re: find objects stored on a specific tablespace David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Ghiurea, Isabella @ 2018-07-18 17:06 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: find objects stored on a specific tablespace
2018-07-18 17:06 find objects stored on a specific tablespace Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca>
@ 2018-07-18 17:10 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2018-07-18 17:10 UTC (permalink / raw)
To: Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-07-18 17:10 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-07-18 17:06 find objects stored on a specific tablespace Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca>
2018-07-18 17:10 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox