pg_relation_size, relation does not exist

From: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_relation_size, relation does not exist
Date: 2009-06-16 11:17:56
Message-ID: 8ec76080906160417i4b92a383i460f98afabb3b296@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A B 2009-06-16 11:21:42 Re: Dynamic table
Previous Message Nishkarsh 2009-06-16 10:48:58 Re: Trigger Function and backup