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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
