From within psql
> what is the sql command in postresql equal to "describe table"?
\d "tablename"
> what is the sql command to list all tables in the database?
\dt
More info and other commands can be found by typing \?
adam