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
bigintDEFAULT NULL,  decimal_type decimal(16,2) DEFAULT NULL,  numeric_type numeric(10,2) DEFAULT NULL,  real_type real
DEFAULTNULL,  doublePrecision_type double precision DEFAULT NULL,  serial_type serial,  bigSerial_type bigserial,
PRIMARYKEY  (data_type_id));
 

dana.