이모저모

ALTER TABLE a_table ALTER COLUMN a_seq ADD GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ) ;

Oracle에서 쓰던 merge문. Postgre의 upsert문과 같은 기능을 가진다. Data가 존재하면 update, 존재하지 않으면 insert. WITH UPSERT AS ( UPDATE AA SET aa_name = I.name, aa_code = I.code FROM BB as I WHERE aa_id = I.id AND I.seq = #{seq} returning * ) INSERT INTO AA ( aa_name, aa_code. ) SELECT I.name, I.code FROM BB as I WHERE I.seq = #{seq} AND (select count(aa_id) from AA where aa_id = I.id )

정말 쓸데없는 썰인데. 참고로 말하자면 난 요즘 도마뱀에 관심이 많다. /***** S : POSTGRESQL 스키마 생성 (Ver. POSTGRESQL 13)**********************************************************/ CREATE TABLE T_GECKO ( SEQ int not null primary key, name varchar(50), kr_name varchar(50), "position" VARCHAR(20), "SORT" NUMERIC(5,0), Life Varchar(50), origin varchar(50), desCription teXt, humidity varchar(50), temperature varchar(50), rearing v..