Re: Table sizes - Mailing list pgsql-general

From Ireneusz Pluta/wp.pl
Subject Re: Table sizes
Date
Msg-id ac5663d1-933d-c453-6c8e-1e92185d7fdc@wp.pl
Whole thread Raw
In response to Table sizes  (luis.roberto@siscobra.com.br)
List pgsql-general
W dniu 2020-09-30 o 14:11, luis.roberto@siscobra.com.br pisze:
> 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 use full tablenames, using schemaname of pg_tables too.




pgsql-general by date:

Previous
From: "Wiltsch,Sigrid"
Date:
Subject: Problem close curser after rollback
Next
From: Charles Clavadetscher
Date:
Subject: Re: Table sizes