Jim Nasby <jna...@enova.com> writes:
> Ahh, duh. Hrm... I ran across this because someone here got confused by this:

> SELECT pg_total_relation_size( schema_name || '.' || relname ) FROM 
> pg_stat_all_tables
> ERROR: relation "moo" does not exist

Personally I'd do that like

           select pg_total_relation_size(oid) from pg_class where ...

and avoid fooling with regclass conversion at all.

                        regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to