{"id":11999,"date":"2022-02-13T13:51:29","date_gmt":"2022-02-13T04:51:29","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=11999"},"modified":"2022-02-13T17:22:49","modified_gmt":"2022-02-13T08:22:49","slug":"postgresql%ec%9d%98-%ec%b2%b4%ed%81%ac-%ec%a0%9c%ec%95%bd-%ec%a1%b0%ea%b1%b4check-constratint%ec%97%90-%ec%a0%95%ea%b7%9c%ed%91%9c%ed%98%84%ec%8b%9d-%ec%a0%81%ec%9a%a9%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=11999","title":{"rendered":"PostgreSQL\uc758 \uccb4\ud06c \uc81c\uc57d \uc870\uac74(Check Constratint)\uc5d0 \uc815\uaddc\ud45c\ud604\uc2dd \uc801\uc6a9\ud558\uae30"},"content":{"rendered":"<p>PostgreSQL\uc740 \ub9e4\uc6b0 \uac15\ub825\ud558\uace0 \ub6f0\uc5b4\ub098\uba70 \uc548\uc815\uc801\uc778 DBMS\uc785\ub2c8\ub2e4. \ud2b9\ud788 \uacf5\uac04 \ub370\uc774\ud130 \ucc98\ub9ac\uc5d0\ub3c4 \ub6f0\uc5b4\ub09c \uba74\ubaa8\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. 2021\ub144 DBMS \uc21c\uc704\uc5d0\uc11c \uc0c1\uc704\uad8c\uc744 \uc218\ub144\uac04 \uc720\uc9c0\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. 1\uc704\ub294 \uc624\ub77c\ud074, 2\uc704\ub294 MySQL, 3\uc704\ub294 MS SQL Server\uc774\uba70 4\uc704\uac00 PostgreSQL\uc785\ub2c8\ub2e4. \uc0ac\uc6a9 \ube48\ub3c4\ub294 \ud0c0 DBMS\uc640 \ube44\uad50\ud558\uc5ec \uc9c0\uc18d\uc801\uc73c\ub85c \uc99d\uac00\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\ud788 \uc720\uc5f0\uc131\uacfc \ud655\uc7a5\uc131\uc744 \uc911\uc2dc\ud558\ub294 \ubd81\ubbf8\uc640 \uc548\uc815\uc131\uc5d0 \ubcf4\uc218\uc801\uc778 \uc77c\ubcf8\uc5d0\uc11c PostgreSQL\uc758 \uc0ac\uc6a9\uc728\uc774 \ub9e4\uc6b0 \ub192\uc2b5\ub2c8\ub2e4. \uc5d4\ud130\ud504\ub77c\uc774\uc988 DB\uc758 \uc774\ubbf8\uc9c0\ub97c \uac15\uc870\ud558\uae30 \uc704\ud574 \ub85c\uace0\ub97c \ucf54\ub07c\ub9ac\ub85c \ud45c\ud604\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/2022\/02\/postgresql.jpg\" alt=\"\" width=\"800\" height=\"400\" class=\"aligncenter size-full wp-image-12003\" \/><\/p>\n<p>\uc0ac\uc6a9\uc790\uac00 \uc785\ub825\ud55c \uac12\uc744 \ud504\ub85c\uadf8\ub798\ubc0d \ucf54\ub4dc\ub97c \ud1b5\ud574\uc11c\ub3c4 \uc720\ud6a8\ud55c\uc9c0 \uac80\uc0ac\ub97c \ud574\uc57c \ud558\uace0 \uc2e4\uc81c \uc11c\ubc84 \ub2e8\uc758 REST API\uc5d0\uc11c\ub3c4 \uc804\ub2ec\ubc1b\uc740 \uac12\uc774 \uc720\ud6a8 \ud55c\uc9c0\ub97c \uac80\uc0ac\ud574\uc57c\ud558\uba70 DBMS\uc5d0 \uc2e4\uc81c \uac12\uc774 \uc785\ub825\ub418\ub294 SQL \ud638\ucd9c\uc5d0\uc11c\ub3c4 \uac12\uc774 \uc720\ud6a8 \ud55c\uc9c0\ub97c \uac80\uc0ac\ud574\uc57c\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub54c \uc785\ub825\ud55c \uac12\uc774 \uc5b4\ub5a4 \uc815\ud574\uc9c4 \uaddc\uce59\uc744 \uc900\uc218\ud558\uace0 \uc788\ub294\uc9c0\uc5d0 \ub300\ud55c \uac80\uc0ac\uac00 \ud544\uc694\ud560 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c\ub4e4\uc5b4\uc11c \uba54\uc77c\uc8fc\uc18c\ub098 \ud578\ub4dc\ud3f0\ubc88\ud638\uc5d0 \ub300\ud55c \uac12\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uaddc\uce59\uc740 \ud754\ud788 \uc815\uaddc\ud45c\ud604\uc2dd\uc73c\ub85c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc815\uaddc\ud45c\ud604\uc2dd\uc740 \uac1c\ubc1c\uc790\ub77c\uba74 \ubc18\ub4dc\uc2dc \uc775\ud600\uc57c \ud558\ub294 \ub3c4\uad6c\uc785\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/2022\/02\/regex.jpg\" alt=\"\" width=\"626\" height=\"360\" class=\"aligncenter size-full wp-image-12004\" \/><\/p>\n<p>\ub2e4\uc74c\uc740 DBMS\uc5d0 INSERT \ubb38\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ub97c \ucd94\uac00\ud560 \ub54c \uac12\uc774 \uc815\ud574\uc9c4 \uaddc\uce59\uc73c\ub85c \uc815\uaddc\ud45c\ud604\uc2dd \ub4f1\uc5d0 \ub9de\ub294\uc9c0 \uac80\uc0ac\ud558\ub3c4\ub85d \ud14c\uc774\ube14 \uc0dd\uc131\uc2dc \uc81c\uc57d\uc870\uac74\uc744 \uac78\uc5b4\uc900 \uc608\uc785\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nCREATE TABLE \"user\" (\r\n    id VARCHAR(20) PRIMARY KEY, -- \uc0ac\uc6a9\uc790 ID\r\n    name VARCHAR(20) NOT NULL,\r\n    mobilephone VARCHAR(13) NOT NULL,\r\n    email VARCHAR(40) NOT NULL,\r\n    CONSTRAINT chk_id CHECK (CHAR_LENGTH(id) >= 3),\r\n    CONSTRAINT chk_name CHECK (CHAR_LENGTH(id) >= 3),\r\n    CONSTRAINT chk_email CHECK (email ~* '^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+[.][A-Za-z]+$'),\r\n    CONSTRAINT chk_mobilephone CHECK (mobilephone ~* '^01[0|1|6|7|8|9]-[0-9]{3,4}-[0-9]{4}$')\r\n);\r\n<\/pre>\n<p>NULL \uac12 \uc785\ub825 \ubc29\uc9c0, \ubb38\uc790\uc5f4\uc5d0 \ub300\ud55c \uc77c \uae38\uc774 \uc774\uc0c1, \uadf8\ub9ac\uace0 \uba54\uc77c\uc774\ub098 \uc804\ud654\ubc88\ud638 \ub4f1\uc758 \ud615\uc2dd\uc5d0 \ub9de\ub294 \uac12\uc778\uc9c0\ub97c \uc815\uaddc\ud45c\ud604\uc2dd\uc744 \uc774\uc6a9\ud574 \uac80\uc0ac\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL\uc740 \ub9e4\uc6b0 \uac15\ub825\ud558\uace0 \ub6f0\uc5b4\ub098\uba70 \uc548\uc815\uc801\uc778 DBMS\uc785\ub2c8\ub2e4. \ud2b9\ud788 \uacf5\uac04 \ub370\uc774\ud130 \ucc98\ub9ac\uc5d0\ub3c4 \ub6f0\uc5b4\ub09c \uba74\ubaa8\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. 2021\ub144 DBMS \uc21c\uc704\uc5d0\uc11c \uc0c1\uc704\uad8c\uc744 \uc218\ub144\uac04 \uc720\uc9c0\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. 1\uc704\ub294 \uc624\ub77c\ud074, 2\uc704\ub294 MySQL, 3\uc704\ub294 MS SQL Server\uc774\uba70 4\uc704\uac00 PostgreSQL\uc785\ub2c8\ub2e4. \uc0ac\uc6a9 \ube48\ub3c4\ub294 \ud0c0 DBMS\uc640 \ube44\uad50\ud558\uc5ec \uc9c0\uc18d\uc801\uc73c\ub85c \uc99d\uac00\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\ud788 \uc720\uc5f0\uc131\uacfc \ud655\uc7a5\uc131\uc744 \uc911\uc2dc\ud558\ub294 \ubd81\ubbf8\uc640 \uc548\uc815\uc131\uc5d0 \ubcf4\uc218\uc801\uc778 \uc77c\ubcf8\uc5d0\uc11c PostgreSQL\uc758 \uc0ac\uc6a9\uc728\uc774 \ub9e4\uc6b0 \ub192\uc2b5\ub2c8\ub2e4. \uc5d4\ud130\ud504\ub77c\uc774\uc988 DB\uc758 \uc774\ubbf8\uc9c0\ub97c \uac15\uc870\ud558\uae30 \uc704\ud574 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=11999\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;PostgreSQL\uc758 \uccb4\ud06c \uc81c\uc57d \uc870\uac74(Check Constratint)\uc5d0 \uc815\uaddc\ud45c\ud604\uc2dd \uc801\uc6a9\ud558\uae30&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-11999","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/11999","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11999"}],"version-history":[{"count":6,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/11999\/revisions"}],"predecessor-version":[{"id":12008,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/11999\/revisions\/12008"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11999"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}