On lör, 2009-11-14 at 10:12 +0000, Garry Saddington wrote: > How could I list all the tables in a database that do not contain any data? > I have looked at reltuples but can't quite work out how to use it, any > pointers would be much apreciated.
select * from pg_class where relkind = 'r' and reltuples = 0; ? Of course reltuples is only a statistic, not an up to date value, but the above should be a pretty helpful start to detect possibly useless tables. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
