{"id":11539,"date":"2021-08-27T06:34:17","date_gmt":"2021-08-26T21:34:17","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=11539"},"modified":"2021-08-27T06:34:17","modified_gmt":"2021-08-26T21:34:17","slug":"postgresql%ec%9d%98-%eb%ac%b8%ec%9e%90%ec%97%b4-%ec%95%94%ed%98%b8%ed%99%94","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=11539","title":{"rendered":"PostgreSQL\uc758 \ubb38\uc790\uc5f4 \uc554\ud638\ud654"},"content":{"rendered":"<p>PostgreSQL \uc790\uccb4 \uae30\ub2a5 \ub9cc\uc73c\ub85c \uc5b4\ub5a4 \ubb38\uc790\uc5f4\uc744 \uc554\ud638\ud654\ud574\uc11c \uc800\uc7a5\ud558\uac70\ub098 \uc554\ud638\ud654\ub41c \ub370\uc774\ud130\ub97c \ub2e4\uc2dc \uc6d0\ub798\uc758 \ubb38\uc790\uc5f4\ub85c \ubcf5\ud638\ud654 \ud558\uae30 \uc704\ud574\uc11c\ub294 pgcrypto\ub77c\ub294 \ud655\uc7a5 \uae30\ub2a5\uc744 \ud65c\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<p>\uba3c\uc800 PostgreSQL\uc5d0\uc11c \ub2e4\uc74c \uba85\ub839\uc744 \ud1b5\ud574 \ud655\uc7a5 \uae30\ub2a5\uc744 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc800 \uac19\uc740 \uacbd\uc6b0 PostgreSQL v10\uc744 \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nCREATE EXTENSION pgcrypto;\r\n<\/pre>\n<p>\uc774\uc81c \uc5b4\ub5a4 \ubb38\uc790\uc5f4\uc744 \uc554\ud638\ud654\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT \r\n    encode(\r\n        encrypt(\r\n            convert_to('GIS \uac1c\ubc1c\uc790, \uae40\ud615\uc900', 'utf8'),\r\n                'encoding_key',\r\n                'aes'\r\n            ),\r\n        'hex'\r\n    );\r\n<\/pre>\n<p>\uc704\uc758 \ucffc\ub9ac\ub294 &#8220;GIS \uac1c\ubc1c\uc790, \uae40\ud615\uc900&#8221; \ubb38\uc790\uc5f4\uc744 &#8220;encoding_key&#8221;\ub97c \uc554\ud638\ud654 \ud0a4\ub85c \uc0ac\uc6a9\ud558\uc5ec AES \uc54c\uace0\ub9ac\uc998\uc73c\ub85c \uc554\ud638\ud654\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uacb0\uacfc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/2021\/08\/postgresql_encrypt.png\" alt=\"\" width=\"800\" class=\"aligncenter size-full wp-image-11541\" \/><\/p>\n<p>\uc774\uc81c \ub2e4\uc2dc \uc554\ud638\ud654\ub41c \ub370\uc774\ud130\ub97c \uc6d0\ub798\uc758 \ubb38\uc790\uc5f4\ub85c \ubcf5\ud638\ud654 \ud558\ub294 \ubc29\ubc95\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nSELECT \r\n    convert_from(\r\n        decrypt(\r\n            decode('12773b7766896ab35aed6b0b5be174d3b4c57c4bde2fc88a982b12946b500943','hex'),\r\n            'decoding_key',\r\n            'aes'\r\n        ),\r\n        'utf8'\r\n    );\r\n<\/pre>\n<p>\uacb0\uacfc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/2021\/08\/postgresql_dencrypt.png\" alt=\"\" width=\"1000\" class=\"aligncenter size-full wp-image-11545\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL \uc790\uccb4 \uae30\ub2a5 \ub9cc\uc73c\ub85c \uc5b4\ub5a4 \ubb38\uc790\uc5f4\uc744 \uc554\ud638\ud654\ud574\uc11c \uc800\uc7a5\ud558\uac70\ub098 \uc554\ud638\ud654\ub41c \ub370\uc774\ud130\ub97c \ub2e4\uc2dc \uc6d0\ub798\uc758 \ubb38\uc790\uc5f4\ub85c \ubcf5\ud638\ud654 \ud558\uae30 \uc704\ud574\uc11c\ub294 pgcrypto\ub77c\ub294 \ud655\uc7a5 \uae30\ub2a5\uc744 \ud65c\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4. \uba3c\uc800 PostgreSQL\uc5d0\uc11c \ub2e4\uc74c \uba85\ub839\uc744 \ud1b5\ud574 \ud655\uc7a5 \uae30\ub2a5\uc744 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc800 \uac19\uc740 \uacbd\uc6b0 PostgreSQL v10\uc744 \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4. CREATE EXTENSION pgcrypto; \uc774\uc81c \uc5b4\ub5a4 \ubb38\uc790\uc5f4\uc744 \uc554\ud638\ud654\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. SELECT encode( encrypt( convert_to(&#8216;GIS \uac1c\ubc1c\uc790, \uae40\ud615\uc900&#8217;, &#8216;utf8&#8217;), &#8216;encoding_key&#8217;, &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=11539\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;PostgreSQL\uc758 \ubb38\uc790\uc5f4 \uc554\ud638\ud654&#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-11539","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\/11539","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=11539"}],"version-history":[{"count":5,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/11539\/revisions"}],"predecessor-version":[{"id":11546,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/11539\/revisions\/11546"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11539"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}