'where' 태그의 글 목록
22-04-12-PostgreSQL-쿼리연습
01.Creat table CREATE TABLE post ( id SERIALPRIMARY KEY, typeVARCHAR(16) NOT NULL default 'default', user_id INTEGER NOT NULL references user(id), titleVARCHAR(256)NOT NULL, descriptionTEXTNOT NULL, child_count INTEGERNOT NULLL default 0, stateVARCHAR(16)NOT NULL DEFAULT 'open', mention_users INTEGER[], ip_addressCHAR(15), infoJSON, parentreferences post(id) create_time TIMESTAMP without time zo..
2022. 4. 12.