tablemeta-data

Hi,

Is there a way to execute a query that returns meta-data about the
tables?  Specifically I am interested in a psql command to display
information about a table's column names and types.

I have moved from MySQL to PostgreSQL to expand my horizons but the SHOW
DATABASES and DESCRIBE some_table commands are the ones I find myself
missing the most.  Perhaps there's some SQL that approximates it.

Thanks,

Erik