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
John Wells wrote:
Guys,
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?
I would assume you would do something like
On Fri, Aug 12, 2005 at 05:26:50PM -0400, John Wells wrote:
>
> 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?
You can get the schemas and tables from the system catalogs or from
the Information Schema (the latt