If you just want to know what your table looks like, try:
select * from pg_class;
To just get the class names, try select relname from pg_class;
I'm pretty sure that you can execute this from psql c-commands.
-Tony