{"id":2509,"date":"2016-12-30T07:14:11","date_gmt":"2016-12-30T07:14:11","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=2509"},"modified":"2020-05-28T16:07:26","modified_gmt":"2020-05-28T07:07:26","slug":"postgresql-create-table-%ec%98%88%ec%a0%9c","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=2509","title":{"rendered":"[PostgreSQL] CREATE TABLE \uc608\uc81c"},"content":{"rendered":"<p>PostgreSQL\uc5d0\uc11c geometry \ud0c0\uc785\uc744 \uac16\ub294 Table\uc744 \uc0dd\uc131\ud558\uace0\uc790 \ud560\ub54c, \uc0ac\uc6a9\ud55c SQL \ubb38\uc5d0 \ub300\ud574 \uc815\ub9ac\ud574 \ubd05\ub2c8\ub2e4. \uc544\ub798\uc640 \uac19\uc740 \ud615\ud0dc\uc758 \ud14c\uc774\ube14 2\uac1c\uc5d0 \ub300\ud55c \uc0dd\uc131\uc778\ub370\uc694.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1083444706.png\" width='550' \/><\/p>\n<p>\uc704 \ud615\ud0dc\uc758 \ud14c\uc774\ube14 2\uac1c\uc5d0 \ub300\ud55c CREATE \ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc2e4\uc81c \uc6a9\ub3c4\ub294 \ub124\ud2b8\uc6cc\ud06c DB\uc5d0 \ub300\ud55c Node, Link \uad00\ub828 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 Table \uc0dd\uc131\uc5d0 \ub300\ud55c SQL\uc785\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nCREATE TABLE public.ecl_network_link\r\n(\r\n  networkid uuid PRIMARY KEY,  \r\n  facility_layer character varying(30),\r\n  snode_id uuid,\r\n  snode_layer character varying(30),\r\n  enode_id uuid,\r\n  enode_layer character varying(30),\r\n  the_geom geometry(MultiLineString)\r\n);\r\n\r\nALTER TABLE public.ecl_network_link\r\n  OWNER TO postgres;\r\n\r\nCREATE INDEX ecl_network_link_geom_idx\r\n  ON public.ecl_network_link\r\n  USING gist\r\n  (the_geom);\r\n<\/pre>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nCREATE TABLE public.ecl_network_node\r\n(\r\n  networkid uuid PRIMARY KEY,  \r\n  facility_layer character varying(30),\r\n  the_geom geometry(Point)\r\n);\r\n\r\nALTER TABLE public.ecl_network_node\r\n  OWNER TO postgres;\r\n\r\nCREATE INDEX ecl_network_node_geom_idx\r\n  ON public.ecl_network_node\r\n  USING gist\r\n  (the_geom);\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL\uc5d0\uc11c geometry \ud0c0\uc785\uc744 \uac16\ub294 Table\uc744 \uc0dd\uc131\ud558\uace0\uc790 \ud560\ub54c, \uc0ac\uc6a9\ud55c SQL \ubb38\uc5d0 \ub300\ud574 \uc815\ub9ac\ud574 \ubd05\ub2c8\ub2e4. \uc544\ub798\uc640 \uac19\uc740 \ud615\ud0dc\uc758 \ud14c\uc774\ube14 2\uac1c\uc5d0 \ub300\ud55c \uc0dd\uc131\uc778\ub370\uc694. \uc704 \ud615\ud0dc\uc758 \ud14c\uc774\ube14 2\uac1c\uc5d0 \ub300\ud55c CREATE \ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc2e4\uc81c \uc6a9\ub3c4\ub294 \ub124\ud2b8\uc6cc\ud06c DB\uc5d0 \ub300\ud55c Node, Link \uad00\ub828 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 Table \uc0dd\uc131\uc5d0 \ub300\ud55c SQL\uc785\ub2c8\ub2e4. CREATE TABLE public.ecl_network_link ( networkid uuid PRIMARY KEY, facility_layer character varying(30), snode_id &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=2509\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;[PostgreSQL] CREATE TABLE \uc608\uc81c&#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":[7],"tags":[],"class_list":["post-2509","post","type-post","status-publish","format-standard","hentry","category-gis-working-history"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2509","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=2509"}],"version-history":[{"count":6,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2509\/revisions"}],"predecessor-version":[{"id":9712,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2509\/revisions\/9712"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2509"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}