* Thom Brown (thombr...@gmail.com) wrote: > psql -U postgres -d test -c "select tablename, > pg_size_pretty(pg_table_size(tablename::regclass)) from pg_tables > where schemaname = 'public' order by tablename;" > > 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
signature.asc
Description: Digital signature
