0

I have many tables/schemas distributed among many tablespaces.

Are there any queries exist/you have found or invented to figure out, which table(s) and misc. belong to which tablespaces and visa-versa (which tablespaces belong to which tables and misc.)?

Thank you for share/reply.

Gen Eva
  • 39
  • 6
  • "Are there any queries ..." -- Yes there are [`pg_class`](https://www.postgresql.org/docs/current/catalog-pg-class.html) and [`pg_tablespace`](https://www.postgresql.org/docs/current/catalog-pg-class.html) are your friends here. – sticky bit Jan 21 '20 at 14:29
  • https://stackoverflow.com/questions/4970966/ –  Jan 21 '20 at 14:36

0 Answers0