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.