Jeff Janes <jeff.janes@gmail.com> writes:
> Is looking for the biggest tables a common enough thing that it should
> be available to everyone, without needing custom customization?
I don't really think so. It's surely not much harder than
select relname, pg_relation_size(oid) from pg_class order by 2 desc;
Moreover, the people who need this likely don't need it as a psql
command, but rather as something available to monitoring tools.
regards, tom lane