Postgres getting the description of a table, specifically column names

Do this:

SELECT column_name, data_type FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'table_name_goes_here';