On Tue, Dec 22, 2020 at 5:08 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> SELECT pg_table_size(table_name::regclass) from information_schema.tables; > ERROR: invalid name syntax > > So how does one go about using a table name from > information_schema.tables in pg_table_size()? > Find that the function signature in the documentation requires an input of "regclass" and ignore attempts to pass anything but that to the function. pg_table_size ( regclass ) → bigint I observe in v13 that the expected syntax works just fine: select pg_table_size((table_schema || '.' || table_name)::regclass) from information_schema.tables; David J.