Re: PostgreSQL 9.0b1 - Error when checking table sizes

* Thom Brown (thombrown@gmail.com) wrote:
> psql -U postgres -d test -c "select tablename,
> pg_size_pretty(pg_table_size(tablename::regclass)) from pg_tables
> where schemaname =3D 'public' order by tablename;"
>=20
> And this, for some reason, works... which is how I did it the other
> day (hence why I've only just got the error today).

public is in your search_path by default- that's why it works.  Still,
it's not really a *good* approach.  Use the one that Tom showed.

    Thanks,

        Stephen