On Aug 12, 2005, at 5:26 PM, John Wells wrote:
I'm getting started with PL/PGSQL but want to understand if the
following
is even possible:
With PL/PGSQL, how would I roll through all tables in my database and
print the table name, along with the row count of that table?
Sorry if this is too simplistic. I've googled but must not be
phrasing my
question properly. Currently reading through the manual, but if
someone
has any helpful tips I'd appreciate it.
There is some code here that shows how to loop through all tables to
grant or revoke access privileges. You can easily adapt it to print
table name and row count.
http://pgedit.com/node/20
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
