From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Information schema sql_identifier |
Date: | 2020-12-23 00:39:22 |
Message-ID: | 669319.1608683962@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
> So how does one go about using a table name from
> information_schema.tables in pg_table_size()?
You want something like
select pg_table_size(quote_ident(table_schema)||'.'||quote_ident(table_name))
from information_schema.tables;
I imagine that the failures you got are a consequence of having
some table names that aren't valid unless quoted (ie contain
spaces, funny characters, etc). In a general-purpose query,
you can't ignore the schema name either.
I might be more excited about v12's failure to provide an implicit
cast to regclass if there were any prospect of queries like this
working in a bulletproof way without accounting for schema names
and funny characters. But there isn't, so the query shown in SO
is a house of cards to start with. When you do it right, with
quote_ident() or format(), no special casting is needed.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-12-23 01:03:38 | Re: Information schema sql_identifier |
Previous Message | David G. Johnston | 2020-12-23 00:33:21 | Re: Information schema sql_identifier |