Jeff,
> Is there a simple way to list all tables without a primary key? Googling
> on this subject has not turned up any helpful sources thus far.
Check out the "newsysviews" project on www.pgfoundry.org. We have a few
views related to keys which you can mine (you'll have to look in CVS, there
have been no releases yet). For example, check out:
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/#dirlist
The view pg_table_constraints lets you find primary keys. If you do an outer
join against pg_user_tables, you can find out which are incomplete.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco