{"id":17340,"date":"2026-10-28T10:41:49","date_gmt":"2026-10-28T01:41:49","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=17340"},"modified":"2026-10-28T10:42:15","modified_gmt":"2026-10-28T01:42:15","slug":"psql%ec%97%90%ec%84%9c-%ec%8a%a4%ed%82%a4%eb%a7%88-%ea%b4%80%eb%a0%a8-%eb%aa%85%eb%a0%b9","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=17340","title":{"rendered":"psql\uc5d0\uc11c \uc2a4\ud0a4\ub9c8 \uad00\ub828  \uba85\ub839"},"content":{"rendered":"<p>\uc2a4\ud0a4\ub9c8\ub97c \uc0dd\uc131\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">\r\nCREATE SCHEMA my_schema;\r\n<\/pre>\n<p>\ud604\uc7ac \uae30\ubcf8\uc73c\ub85c \uc9c0\uc815\ub41c \uc2a4\ud0a4\ub9c8\ub97c \ud655\uc778\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">\r\nSHOW search_path;\r\n<\/pre>\n<p>\uc6d0\ud558\ub294 \uc2a4\ud0a4\ub9c8\ub97c \uae30\ubcf8\uc73c\ub85c \uc9c0\uc815\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">\r\nSET search_path my_schema;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc2a4\ud0a4\ub9c8\ub97c \uc0dd\uc131\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. CREATE SCHEMA my_schema; \ud604\uc7ac \uae30\ubcf8\uc73c\ub85c \uc9c0\uc815\ub41c \uc2a4\ud0a4\ub9c8\ub97c \ud655\uc778\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. SHOW search_path; \uc6d0\ud558\ub294 \uc2a4\ud0a4\ub9c8\ub97c \uae30\ubcf8\uc73c\ub85c \uc9c0\uc815\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. SET search_path my_schema;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[158],"tags":[],"class_list":["post-17340","post","type-post","status-publish","format-standard","hentry","category-postgresql"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/17340","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=17340"}],"version-history":[{"count":3,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/17340\/revisions"}],"predecessor-version":[{"id":17343,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/17340\/revisions\/17343"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17340"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}