Describe Table

I've reviewed much of the documentation and the forums,
but unable to seem to find a easy way to obtain the same
thing as the 'psql \d table' through sql. I know I can create
through collecting info on table, but seems there must be an
easier way. I desire to create a standard type SQL dump
syntax.

ex.
DROP TABLE IF EXISTS postgresqltypes;
CREATE TABLE postgresqltypes (

-- Table id and creation data entries.

data_type_id serial NOT NULL,
smallInt_type smallint DEFAULT NULL,
int_type integer DEFAULT NULL,
bigInt_type bigint DEFAULT NULL,
decimal_type decimal(16,2) DEFAULT NULL,
numeric_type numeric(10,2) DEFAULT NULL,
real_type real DEFAULT NULL,
doublePrecision_type double precision DEFAULT NULL,
serial_type serial,
bigSerial_type bigserial,
PRIMARY KEY (data_type_id));

dana.