Beth Gatewood <bethg(at)mbt(dot)washington(dot)edu> writes:
> I would really like to write some code that would be able to query any
> database, grab out the tables and then do a row count on each table.
> Obviously I could do this by hand, singly executing \dt but this will
> be taking a long time.
psql's backslash commands don't do anything you couldn't do for
yourself. To see what they're doing, start psql with -E switch to
make it echo the SQL commands it's sending.
One thing you do have to watch out for is that details of the system
catalogs tend to change from release to release, so if you do anything
too fancy you might find it broken at some point in the future...
regards, tom lane