{"id":2499,"date":"2016-11-28T10:13:31","date_gmt":"2016-11-28T10:13:31","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=2499"},"modified":"2016-11-28T10:13:31","modified_gmt":"2016-11-28T10:13:31","slug":"postgresql%ec%97%90%ec%84%9c-uuid-type-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%bf%bc%eb%a6%ac-%eb%b0%8f-%ec%97%85%eb%8d%b0%ec%9d%b4%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=2499","title":{"rendered":"PostgreSQL\uc5d0\uc11c UUID Type \ub370\uc774\ud130 \ucffc\ub9ac \ubc0f \uc5c5\ub370\uc774\ud2b8"},"content":{"rendered":"<p>ID\uc5d0 \ub300\ud55c \uace0\uc720\ud55c \uac12\uc73c\ub85c\uc368 \uc0ac\uc6a9\ud560\ub9cc\ud55c Type\uc73c\ub85c PostgreSQL\uc5d0\uc11c\ub294 UUID \ud0c0\uc785\uc744 \uc81c\uacf5\ud558\ub294\ub370\uc694. \uc774 \ub370\uc774\ud130 \ud0c0\uc785\uc73c\ub85c \uc870\ud68c\ud558\uac70\ub098 Update\ud558\ub294 \uc608\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>\nselect * from ecl_logic_node_p where networkid::text = '176f54c1-f333-426f-b4d5-29c365ec3ac3'\nselect * from ecl_logic_node_p where networkid = '176f54c1-f333-426f-b4d5-29c365ec3ac3'\nselect * from ecl_logic_node_p where networkid = '176f54c1-f333-426f-b4d5-29c365ec3ac3'::uuid\n\nselect networkid::text from ecl_logic_node_p\n\nupdate ecl_logic_node_p set networkid = '176f54c1-f333-426f-b4d5-29c365ec3acf' where fid = 0\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>ID\uc5d0 \ub300\ud55c \uace0\uc720\ud55c \uac12\uc73c\ub85c\uc368 \uc0ac\uc6a9\ud560\ub9cc\ud55c Type\uc73c\ub85c PostgreSQL\uc5d0\uc11c\ub294 UUID \ud0c0\uc785\uc744 \uc81c\uacf5\ud558\ub294\ub370\uc694. \uc774 \ub370\uc774\ud130 \ud0c0\uc785\uc73c\ub85c \uc870\ud68c\ud558\uac70\ub098 Update\ud558\ub294 \uc608\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. select * from ecl_logic_node_p where networkid::text = &#8216;176f54c1-f333-426f-b4d5-29c365ec3ac3&#8217; select * from ecl_logic_node_p where networkid = &#8216;176f54c1-f333-426f-b4d5-29c365ec3ac3&#8217; select * from ecl_logic_node_p where networkid = &#8216;176f54c1-f333-426f-b4d5-29c365ec3ac3&#8217;::uuid select networkid::text from ecl_logic_node_p update ecl_logic_node_p set networkid = &#8216;176f54c1-f333-426f-b4d5-29c365ec3acf&#8217; where fid = &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=2499\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;PostgreSQL\uc5d0\uc11c UUID Type \ub370\uc774\ud130 \ucffc\ub9ac \ubc0f \uc5c5\ub370\uc774\ud2b8&#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":[8],"tags":[],"class_list":["post-2499","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2499","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=2499"}],"version-history":[{"count":0,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2499\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2499"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}