database and table listing

are there any SQL statements which I can type into the psql client to give
a listing of available databases, available tables (within a database), and
to view the structure of a single table.


--
Kindness is a language which the deaf can hear and the blind can read.
        -- Mark Twain

--    --    --    --    --    --    --    --    --    --

Stephen Patterson    steve@foxx.UKL.net

(Replace UKL with uklinux to reply)