What's the best way to count how many rows are in each table via SQL? Or
is it even possible?
I'm trying something like:
select tablename, count(*) from (select tablename from pg_tables where
schemaname = 'public') as test group by tablename;
But obviously this just gives a count of 1 for each table in the public
schema.
Can it be done or would I have to write a function?
--
Paul Lambert
Database Administrator
AutoLedgers