Обсуждение: showing tables and columns

Is there a way to construct a SQL statement to retrieve all the tables
and also columns information ?

I know, using \d from psql shows the table and \d tablename will show
the columns but that does not work from within jdbc.

Thanks
Mir