SQL/Postgresql

date timestamp default 사용

아직미정임 2022. 3. 23. 00:48

date timestamp default current_timestamp -> 현재시간이 자동으로 들어간다.

create sequence eventweb_id_seq;

CREATE TABLE eventweb(
    id integer not null default nextval('eventweb_id_seq'::regclass),
    title character varying(10485760) COLLATE pg_catalog."default",
    subject character varying(10485760) COLLATE pg_catalog."default",
    date timestamp default current_timestamp,
    adminid character varying(256) COLLATE pg_catalog."default",
    active boolean,
    image character varying(256),
    CONSTRAINT eventweb_pkey PRIMARY KEY (id)
);