16 Aug
2002
16 Aug
'02
4:31 p.m.
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 );