How do I list the schema for a table or procedure? Is there a command I can do in psql to list this, or do I have to join a series of tables to see that?
You can do a "pg_dump -s <DBNAME>" to see the full schema of the database. To see just a table of the database issue the command "pg_dump -st <TABLENAME> <DBNAME>". These are run from the command line and not within the psql shell.
Within psql you could use "\d <TABLENAME>" to describe a specific table.
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match