Thread: [NOVICE] Old solutions for listing tables by tablespace broken in PG 10 forpartitions.
[NOVICE] Old solutions for listing tables by tablespace broken in PG 10 forpartitions.
I have tried the solutions for listing tables in a tablespace here:
select relname from pg_class where reltablespace=(select oid from pg_tablespace where spcname='xyz');
and here:
https://stackoverflow.com/questions/4970966/how-can-i-tell-what-is-in-a-postgresql-tablespace
SELECT
c.relname,
t.spcname
FROM
pg_class c
JOIN pg_tablespace t ON c.reltablespace = t.oid
WHERE
t.spcname = 'indexes_old';
I don’t see partitioned tables in the list. How do I get a list of tables including partitions by tablespace?
Stephen Froehlich
Sr. Strategist, CableLabs®
s.froehlich@cablelabs.com
Tel: +1 (303) 661-3708
[NOVICE] Re: Old solutions for listing tables by tablespace broken in PG 10for partitions.
Found it:
SELECT tablename from pg_tables WHERE tablespace = ‘foo’;
--Stephen
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Stephen Froehlich
Sent: Saturday, November 04, 2017 12:35 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Old solutions for listing tables by tablespace broken in PG 10 for partitions.
This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing |
CableLabs WARNING: The sender of this email could not be validated and may not match the person in the "From" field.
I have tried the solutions for listing tables in a tablespace here:
select relname from pg_class where reltablespace=(select oid from pg_tablespace where spcname='xyz');
and here:
https://stackoverflow.com/questions/4970966/how-can-i-tell-what-is-in-a-postgresql-tablespace
SELECT
c.relname,
t.spcname
FROM
pg_class c
JOIN pg_tablespace t ON c.reltablespace = t.oid
WHERE
t.spcname = 'indexes_old';
I don’t see partitioned tables in the list. How do I get a list of tables including partitions by tablespace?