Does anyone know the comparable SQL for Postgresql. CREATE TABLE log ( log_id integer DEFAULT nextval('log_id_seq'::text), severity character varying(32) DEFAULT 'INFO' NOT NULL, subsystem character varying(80) DEFAULT 'DTML' NOT NULL, summary character varying(256) DEFAULT '' NOT NULL, detail character varying(8192) DEFAULT '' NOT NULL, log_time timestamp(2) without time zone DEFAULT ('now'::text)::timestamp(6) with time zone );
apart from the fact that this question is off-topic on this list, postgres documentation is available online:: http://www.postgresql.org/idocs/index.php?user.html jens On Friday, August 16, 2002, at 12:00 , eric.n.dunn@bankofamerica.com wrote:
Does anyone know the comparable SQL for Postgresql.
CREATE TABLE log ( log_id integer DEFAULT nextval('log_id_seq'::text), severity character varying(32) DEFAULT 'INFO' NOT NULL, subsystem character varying(80) DEFAULT 'DTML' NOT NULL, summary character varying(256) DEFAULT '' NOT NULL, detail character varying(8192) DEFAULT '' NOT NULL, log_time timestamp(2) without time zone DEFAULT ('now'::text)::timestamp(6) with time zone );
participants (2)
-
eric.n.dunn@bankofamerica.com -
Jens Vagelpohl