pg_relation_size, relation does not exist - Mailing list pgsql-general

From Whit Armstrong
Subject pg_relation_size, relation does not exist
Date
Msg-id 8ec76080906160417i4b92a383i460f98afabb3b296@mail.gmail.com
Whole thread Raw
Responses Re: pg_relation_size, relation does not exist
List pgsql-general
Does anyone know why I get an unknown relation error when I query for
relation size?

kls=# select tablename, pg_size_pretty(pg_relation_size(tablename))
from pg_tables where schemaname = 'econ' order by tablename;
ERROR:  relation "series_info" does not exist
kls=#

Is there a better way to do this query to avoid this error?

Thanks,
Whit

pgsql-general by date:

Previous
From: Nishkarsh
Date:
Subject: Re: Trigger Function and backup
Next
From: A B
Date:
Subject: Re: Dynamic table