Re: pg_relation_size, relation does not exist

Thanks, Frank.

That works perfectly.

Cheers,
Whit

On Tue, Jun 16, 2009 at 7:36 AM, Frank Heikens<frankheikens(at)mac(dot)com> wrote:
> The search_path isn't correct. You're looking for the size of tables in
> schema 'econ' but you don't mention this schema inside the function
> pg_relation_size(). Try to  use the schemanames as well, saves you a lot of
> problems with assumptions.
>
> This one should work:
>
> SELECT
>        tablename,
>        pg_size_pretty(pg_relation_size(schemaname || '.' || tablename))
> FROM
>        pg_tables
> WHERE
>        schemaname = 'econ';
>
>
> Kind regard,
> Frank
>
>
> Op 16 jun 2009, om 13:17 heeft Whit Armstrong het volgende geschreven:
>
>> 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
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>