[Q] how to find how many row in each table in database?

Hi,

   I want to call a C program from a stored procedure. I was thinking    of using "pipes" to accomplish this. Does anyone have a better    idea ?

   Thanks for your answers !