Re: [GENERAL] Seeking PL/PGSQL example

2005-08-13 Thread John DeSoi
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

Re: [GENERAL] Seeking PL/PGSQL example

2005-08-12 Thread Chris Travers
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

Re: [GENERAL] Seeking PL/PGSQL example

2005-08-12 Thread Michael Fuhr
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