Re: pg_relation_size, relation does not exist

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