De: "Charles Clavadetscher" <clavadetscher@swisspug.org> Para: "luis.roberto" <luis.roberto@siscobra.com.br> Cc: "pgsql-general" <pgsql-general@lists.postgresql.org> Enviadas: Quarta-feira, 30 de setembro de 2020 10:46:39 Assunto: Re: Table sizes
Hello
On 2020-09-30 14:11, luis.roberto@siscobra.com.br wrote: > Hi! > > I'm trying to use this query to get table sizes, however I'm getting a > strange error: > > select tablename,pg_relation_size(tablename::text) > from pg_tables; > > In PG 13: > > SQL Error [42P01]: ERROR: relation "sql_implementation_info" does not > exist > > In PG 12: > > SQL Error [42P01]: ERROR: relation "sql_parts" does not exist
You need to schema qualify the tables. Additionally, if you happen to have table names that have a mix of capital and non capital letters or contain other characters that might be problematic, you need to enclose the table name in double quotes.
Regards Charles
-- Charles Clavadetscher Swiss PostgreSQL Users Group Treasurer Spitzackerstrasse 9 CH - 8057 Zürich