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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
