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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general