{"id":2393,"date":"2025-03-18T08:51:32","date_gmt":"2025-03-17T23:51:32","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=2393"},"modified":"2025-03-18T13:33:09","modified_gmt":"2025-03-18T04:33:09","slug":"postgresql-json","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=2393","title":{"rendered":"PostgreSQL JSON"},"content":{"rendered":"<h3>\uc6d0\ubb38\ucd9c\ucc98 : http:\/\/www.postgresqltutorial.com\/postgresql-json\/<\/h3>\n<p><P>\uc774 \ud29c\ud1a0\ub9ac\uc5bc\uc740 PostgreSQL\uc758 JSON \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ud558\ub294\uc9c0 \uc124\uba85\ud55c\ub2e4. \ucd94\uac00\uc801\uc73c\ub85c JSON \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \uc5f0\uc0b0\uc790\uc640 \ud568\uc218\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc124\uba85\ud55c\ub2e4.<\/P><\/p>\n<p><P>JSON\uc740 JavaScript Object Notation\uc774\ub2e4. JSON\uc73c\ub85c \ub2e4\uc591\ud55c \ub370\uc774\ud130\ub97c \ud45c\ud604\ud560 \uc218 \uc788\uc9c0\ub9cc \ud2b9\ud788 \ud0a4-\uac12\uc73c\ub85c \uad6c\uc131\ub41c \uc27d\uac8c \ud574\uc11d\ud560 \uc218 \uc788\ub294 \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc774\ub2e4. JSON\uc758 \uc8fc\uc694 \uc0ac\uc6a9\ucc98\ub294 \uc11c\ubc84\uc640 \uc6f9 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \uc0ac\uc774\uc758 \ub370\uc774\ud130 \uad50\ud658 \ubc0f \uc804\uc1a1\uc774\ub2e4. \ubc14\uc774\ub108\ub9ac \ud615\uc2dd\uacfc \ub2e4\ub974\uac8c JSON\uc740 \uc0ac\ub78c\uc774 \uc774\ud574\ud558\uace0 \uc77d\uc744 \uc218 \uc788\ub294 \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc774\ub2e4.<\/P><\/p>\n<p><P>PostgreSQL\uc740 9.2\ubc84\uc804 \uc774\ud6c4\ubd80\ud130 JSON \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc9c0\uc6d0\ud558\uba70 JSON \ub370\uc774\ud130\ub97c \uc870\uc791\ud558\uae30 \uc704\ud55c \ub2e4\uc591\ud55c \ud568\uc218\uc640 \uc5f0\uc0b0\uc790\ub97c \uc81c\uacf5\ud55c\ub2e4.<\/P><\/p>\n<p><P>JSON \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc774\ud574\ub97c \uc704\ud574 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \uac83\ubd80\ud130 \uc2dc\uc791\ud574 \ubcf4\uc790.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nCREATE TABLE orders (\r\n    ID serial NOT NULL PRIMARY KEY,\r\n    info json NOT NULL\r\n);\r\n<\/pre>\n<p><P>orders \ud14c\uc774\ube14\uc740 2\uac1c\uc758 \uceec\ub7fc\uc73c\ub85c \uad6c\uc131 \ub418\uc5b4\uc838 \uc788\ub294\ub370, id\ub294 \uc21c\uc11c\ub97c \ub098\ud0c0\ub0b4\ub294 \uc8fc \ud0a4\uc774\uba70 info\ub294 JSON \ud615\uc2dd\uc73c\ub85c \ub370\uc774\ud130\uac00 \uc800\uc7a5\ub420 \uceec\ub7fc\uc774\ub2e4.<\/P><\/p>\n<h3>JSON \ub370\uc774\ud130 INSERT<\/h3>\n<p>JSON \uceec\ub7fc\uc5d0 \ub370\uc774\ud130\ub97c \uc785\ub825\ud558\uae30 \uc704\ud574\uc11c \uc62c\ubc14\ub978 JSON \ud3ec\ub9f7\uc758 \ub370\uc774\ud130\uac00 \ud544\uc694\ud558\ub2e4. \ub2e4\uc74c INSERT \uad6c\ubb38\uc740 orders \ud14c\uc774\ube14\uc5d0 \uc0c8\ub85c\uc6b4 \ub808\ucf54\ub4dc\ub97c \ucd94\uac00\ud55c\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nINSERT INTO orders (info)\r\nVALUES\r\n(\r\n    '{ \"customer\": \"John Doe\", \"items\": {\"product\": \"Beer\",\"qty\": 6}}'\r\n);\r\n<\/pre>\n<p><P>\uc704\uc758 \ub370\uc774\ud130\ub294 6\ubcd1\uc758 \ub9e5\uc8fc\ub97c \uac00\uc9c4 John Doe\ub97c \uc758\ubbf8\ud55c\ub2e4.<\/P><\/p>\n<p><P>\ub9c8\ucc2c\uac00\uc9c0\ub85c \uc5ec\ub7ec \uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \ucd94\uac00\ud574 \ubcf4\uc790.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nINSERT INTO orders (info)\r\nVALUES\r\n(\r\n    '{ \"customer\": \"Lily Bush\", \"items\": {\"product\": \"Diaper\",\"qty\": 24}}'\r\n),\r\n(\r\n    '{ \"customer\": \"Josh William\", \"items\": {\"product\": \"Toy Car\",\"qty\": 1}}'\r\n),\r\n(\r\n    '{ \"customer\": \"Mary Clark\", \"items\": {\"product\": \"Toy Train\",\"qty\": 2}}'\r\n);\r\n<\/pre>\n<h3>JSON \ub370\uc774\ud130 \ucffc\ub9ac<\/h3>\n<p><P>JSON \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\uae30 \uc704\ud574\uc11c \uc77c\ubc18\uc801\uc778 \ub2e4\ub978 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ucffc\ub9ac \ud558\ub4ef\uc774 SELECT \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud55c\ub2e4.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n info\r\nFROM\r\n orders;\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1192706213.jpg\" \/><\/p>\n<p><P>PostgreSQL\uc740 \uadf8 \uacb0\uacfc\ub97c JSON \ud615\ud0dc\uc758 \uc9d1\ud569\uc73c\ub85c \ubc18\ud658\ud55c\ub2e4.<\/P><\/p>\n<p><P>PostgreSQL\uc740 JSON \ub370\uc774\ud130\uc5d0 \ub300\ud55c \ucffc\ub9ac\ub97c \ub3d5\uae30 \uc704\ud574 ->\uacfc ->> \uc5f0\uc0b0\uc790\ub97c \uc81c\uacf5\ud55c\ub2e4.<\/P><\/p>\n<p><UL><br \/>\n<LI>&#8220;->&#8221; \uc5f0\uc0b0\uc790\ub294 \ud0a4\ub85c JSON \ub370\uc774\ud130 \ud544\ub4dc\ub97c \ubc18\ud658\ud55c\ub2e4.<\/LI><br \/>\n<LI>&#8220;->>&#8221; \uc5f0\uc0b0\uc790\ub294 \ud14d\uc2a4\ud2b8\ub85c JSON \ub370\uc774\ud130 \ud544\ub4dc\ub97c \ubc18\ud658\ud55c\ub2e4.<\/LI><br \/>\n<\/UL><\/p>\n<p><P>\ub2e4\uc74c \ucffc\ub9ac\ub294 JSON \ud615\uc2dd\uc73c\ub85c \ubaa8\ub4e0 \uace0\uac1d \uc815\ubcf4\ub97c \uc5bb\uae30 \uc704\ud574 -> \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n    info -> 'customer' AS customer\r\nFROM\r\n    orders;\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1395699102.jpg\" \/><\/p>\n<p><P>\uadf8\ub9ac\uace0 ->> \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud558\ub294 \ub2e4\uc74c\uc758 \ucffc\ub9ac\ubb38\uc740 \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc73c\ub85c \ubaa8\ub4e0 \uace0\uac1d \uc815\ubcf4\ub97c \ubc18\ud658\ud55c\ub2e4.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n    info ->> 'customer' AS customer\r\nFROM\r\n    orders;\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1213767617.jpg\" \/><\/p>\n<p><P>-> \uc5f0\uc0b0\uc790\uac00 JSON \uac1d\uccb4\ub97c \ubc18\ud658\ud558\ubbc0\ub85c, \uc5f0\uad00\ub41c \ub178\ub4dc\ub97c \ubc18\ud658\uc2dc\ud0a4\uae30 \uc704\ud574 ->> \uc5f0\uc0b0\uc790\uc640 \ud568\uaed8 \uc5f0\uacb0 \ud638\ucd9c\uc774 \uac00\ub2a5\ud558\ub2e4. \uc608\ub97c\ub4e4\uc5b4 \uc544\ub798\uc758 \uad6c\ubb38\uc740 \ud310\ub9e4\ub41c \ubaa8\ub4e0 \uc81c\ud488\uc744 \ubc18\ud658\ud55c\ub2e4.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n    info -> 'items' ->> 'product' as product\r\nFROM\r\n    orders\r\nORDER BY\r\n    product;\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1390305481.jpg\" \/><\/p>\n<p><P>\uba3c\uc800 info->&#8217;items&#8217;\ub294 JSON \uac1d\uccb4\ub85c\uc368 \ud56d\ubaa9\uc744 \ubc18\ud658\ud55c\ub2e4. \uadf8\ub7f0 \ub4a4 info->&#8217;items&#8217;->>&#8217;product&#8217;\ub294 \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc73c\ub85c \ubaa8\ub4e0 product\ub97c \ubc18\ud658\ud55c\ub2e4.<\/P><\/p>\n<h3>WHERE \uad6c\ubb38\uc5d0\uc11c JSON \uc5f0\uc0b0\uc790 \uc0ac\uc6a9<\/h3>\n<p><P>\uc870\uac74 \uac80\uc0c9\uc744 \uc9c0\uc815\ud558\uae30 \uc704\ud574 WHERE \uad6c\ubb38\uc5d0\uc11c JSON \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. \uc608\ub97c\ub4e4\uc5b4 Diaper\ub97c \uac00\uc838\uc628 \uc0ac\ub78c\uc744 \uc5bb\uace0\uc790 \ud55c\ub2e4\uba74 \ub2e4\uc74c \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud55c\ub2e4.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n    info ->> 'customer' AS customer\r\nFROM\r\n    orders\r\nWHERE\r\n    info -> 'items' ->> 'product' = 'Diaper'\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1087837191.jpg\" \/><\/p>\n<p><P>\ub610 \ub2e4\ub978 \uc608\ub85c\uc368, \ub2e4\uc74c\uc758 \ucffc\ub9ac\ub294 2\uac1c\uc758 product\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \ub808\ucf54\ub4dc\ub97c \uc870\ud68c\ud55c\ub2e4.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n    info ->> 'customer' AS customer,\r\n    info -> 'items' ->> 'product' AS product\r\nFROM\r\n    orders\r\nWHERE\r\n    CAST( info -> 'items' ->> 'qty' AS INTEGER ) = 2\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1350422715.jpg\" \/><\/p>\n<p><P>\uc704\uc758 \ucffc\ub9ac\ubb38\uc5d0\uc11c \uc8fc\ubaa9\ud574\uc57c \ud560 \ubd80\ubd84\uc740 qty \ud544\ub4dc\ub97c \uc22b\uc790 2\uc640 \ube44\uad50\ud558\uae30 \uc704\ud574 INTEGER\ub85c \ud615\ubcc0\ud658(Casting)\ud588\ub2e4\ub294 \uac83\uc774\ub2e4.<\/P><\/p>\n<h3>JSON \ub370\uc774\ud130\uc5d0 \uc9d1\uacc4 \ud568\uc218 \uc801\uc6a9\ud558\uae30<\/h3>\n<p><P>MIN, MAX, AVERAGE, SUM \ub4f1\uacfc \uac19\uc740 \uc9d1\uacc4 \ud568\uc218\ub97c JSON \ub370\uc774\ud130\uc5d0 \uc801\uc6a9\ud560 \uc218 \uc788\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c \uad6c\ubb38\uc740 \ucd5c\uc18c \uac1c\uc218, \ucd5c\ub300 \uac1c\uc218, \ud3c9\uade0 \uac1c\uc218\uc640 \uc804\uccb4 \ud310\ub9e4\ub41c \uc0c1\ud488\uc758 \uac1c\uc218\uc5d0 \ub300\ud55c \ucffc\ub9ac\ubb38\uc774\ub2e4.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n    MIN (\r\n        CAST (info -> 'items' ->> 'qty' AS INTEGER)\r\n    ),\r\n    MAX (\r\n        CAST (info -> 'items' ->> 'qty' AS INTEGER)\r\n    ),\r\n    SUM (\r\n        CAST (info -> 'items' ->> 'qty' AS INTEGER)\r\n    ),\r\n    AVG (\r\n        CAST (info -> 'items' ->> 'qty' AS INTEGER)\r\n     )\r\nFROM orders\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1078689309.jpg\" \/><\/p>\n<h3>PostgreSQL\uc758 JSON \ud568\uc218<\/h3>\n<p><P>PostgreSQL\uc740 JSON \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\ub294\ub370 \ub3c4\uc6c0\uc774 \ub418\ub294 \ud568\uc218\ub4e4\uc744 \uc81c\uacf5\ud55c\ub2e4.<\/p>\n<h4>json_each \ud568\uc218<\/h4>\n<p>json_each \ud568\uc218\ub294 \ud0a4-\uac12\uc758 \uc9d1\ud569\uc73c\ub85c JSON \uac1d\uccb4\ub97c \ud655\uc7a5\uc2dc\ud0a8\ub2e4. \ub2e4\uc74c \uad6c\ubb38\uc744 \ubcf4\uc790.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n    json_each (info)\r\nFROM\r\n    orders;\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1113779134.jpg\" \/><\/p>\n<p><P>\ub9cc\uc57d \ubb38\uc790\ud615\uc73c\ub85c \ud0a4-\uac12\uc758 \uc9d1\ud569\uc744 \uc5bb\uace0\uc790 \ud55c\ub2e4\uba74, json_each_text \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/P><\/p>\n<h4>json_object_keys \ud568\uc218<\/h4>\n<p>JSON \uac1d\uccb4\uc758 \ud0a4 \uc9d1\ud569\uc744 \uc5bb\uace0\uc790 \ud55c\ub2e4\uba74, json_object_keys \ud568\uc218\ub97c \uc0ac\uc6a9\ud55c\ub2e4. \ub2e4\uc74c\uc758 \ucffc\ub9ac\ub294 info \uceec\ub7fc \uc548\uc758 items \uac1d\uccb4\uc758 \ubaa8\ub4e0 \ud0a4\ub97c \ubc18\ud658\ud55c\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n    json_object_keys (info->'items')\r\nFROM\r\n    orders;\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1131036220.jpg\" \/><\/p>\n<h4>json_typeof \ud568\uc218<\/h4>\n<p><P>json_typeof \ud568\uc218\ub294 \ubb38\uc790\uc5f4\ub85c JSON \uac12\uc758 \ud0c0\uc785\uc744 \ubc18\ud658\ud558\uba70, \ubc18\ud658\uac12\uc740 number, boolean, null, object, array \uadf8\ub9ac\uace0 string\uc774\ub2e4.<\/P><\/p>\n<p><P>\ub2e4\uc74c \ucffc\ub9ac\ubb38\uc740 \ud56d\ubaa9\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ubc18\ud658\ud55c\ub2e4.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n    json_typeof (info->'items')\r\nFROM\r\n    orders;\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1269893818.jpg\" \/><\/p>\n<p><P>\ub2e4\uc74c\uc758 \ucffc\ub9ac\ubb38\uc740 \uc911\ucca9\ub418\uc5b4\uc9c4 JSON \uac1d\uccb4\uc758 qty \ud544\ub4dc\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ubc18\ud658\ud55c\ub2e4.<\/P><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT\r\n    json_typeof (info->'items'->'qty')\r\nFROM\r\n    orders;\r\n<\/pre>\n<p style=\"text-align: center;\"><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1079377590.jpg\" \/><\/p>\n<p><P>JSON \ud568\uc218\uc5d0 \ub300\ud574 \uc880\ub354 \uae4a\uc774 \uc54c\uace0\uc790 \ud55c\ub2e4\uba74, <A href='https:\/\/www.postgresql.org\/docs\/9.4\/static\/functions-json.html'>PostgreSQL JSON functions<\/A>\uc744 \ucc38\uace0\ud558\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/P><\/p>\n<p><P>\uc774 \ud29c\ud1a0\ub9ac\uc5bc\uc5d0\uc11c\ub294, PostgreSQL JSON \ub370\uc774\ud130 \ud0c0\uc785\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc558\ub2e4. \ub610\ud55c JSON \ub370\uc774\ud130\ub97c \uc880\ub354 \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ud558\uae30 \uc704\ud574\uc11c \uac00\uc7a5 \ub9ce\uc774 \ud65c\uc6a9\ub418\ub294 JSON \uc5f0\uc0b0\uc790\uc640 \ud568\uc218\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc0b4\ud3b4\ubcf4\uc558\ub2e4.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc6d0\ubb38\ucd9c\ucc98 : http:\/\/www.postgresqltutorial.com\/postgresql-json\/ \uc774 \ud29c\ud1a0\ub9ac\uc5bc\uc740 PostgreSQL\uc758 JSON \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ud558\ub294\uc9c0 \uc124\uba85\ud55c\ub2e4. \ucd94\uac00\uc801\uc73c\ub85c JSON \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \uc5f0\uc0b0\uc790\uc640 \ud568\uc218\uc5d0 \ub300\ud574\uc11c\ub3c4 \uc124\uba85\ud55c\ub2e4. JSON\uc740 JavaScript Object Notation\uc774\ub2e4. JSON\uc73c\ub85c \ub2e4\uc591\ud55c \ub370\uc774\ud130\ub97c \ud45c\ud604\ud560 \uc218 \uc788\uc9c0\ub9cc \ud2b9\ud788 \ud0a4-\uac12\uc73c\ub85c \uad6c\uc131\ub41c \uc27d\uac8c \ud574\uc11d\ud560 \uc218 \uc788\ub294 \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc774\ub2e4. JSON\uc758 \uc8fc\uc694 \uc0ac\uc6a9\ucc98\ub294 \uc11c\ubc84\uc640 \uc6f9 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \uc0ac\uc774\uc758 \ub370\uc774\ud130 \uad50\ud658 \ubc0f \uc804\uc1a1\uc774\ub2e4. \ubc14\uc774\ub108\ub9ac \ud615\uc2dd\uacfc &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=2393\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;PostgreSQL JSON&#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-2393","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\/2393","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=2393"}],"version-history":[{"count":7,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2393\/revisions"}],"predecessor-version":[{"id":15795,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2393\/revisions\/15795"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2393"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}