> How would I list all tables in a database?
You can list all tables with:
select * from pg_class;
but that will give you system tables also.
I think that if you use the \z command in psql, it will give you a list
of all tables in the current database.
Matt