[Zope] (no subject)

eric.n.dunn@bankofamerica.com eric.n.dunn@bankofamerica.com
Fri, 16 Aug 2002 12:00:22 -0400


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
    );