{"id":1928,"date":"2013-12-20T10:16:58","date_gmt":"2013-12-20T10:16:58","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1928"},"modified":"2017-01-27T12:09:31","modified_gmt":"2017-01-27T03:09:31","slug":"psql%ec%97%90%ec%84%9c-insert-%eb%ac%b8-%ec%8b%a4%ed%96%89%ec%8b%9c-%ed%95%9c%ea%b8%80-%eb%ac%b8%ec%a0%9c","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1928","title":{"rendered":"psql\uc5d0\uc11c INSERT \ubb38 \uc2e4\ud589\uc2dc \ud55c\uae00 \ubb38\uc81c"},"content":{"rendered":"<p>postgreSQL\uc758 \ucf58\uc194\uc778 psql\uc5d0\uc11c \uc9c1\uc811 SQL\ubb38\uc744 \ub358\uc838\uc11c \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uace0 \ub370\uc774\ud130\ub97c INSERT\ud560\ub54c \ud55c\uae00 \ub370\uc774\ud130\uc5d0\uc11c INSERT \ubb38\uc758 \uc2e4\ud589 \uc870\ucc28 \ub418\uc9c0 \uc54a\ub294 \ubb38\uc81c\ub294 postgreSQL\uc5d0 \ub300\ud55c \uc11c\ubc84 \uce21\uacfc \ud074\ub77c\uc774\uc5b8\ud2b8 \uce21\uc758 \ud55c\uae00 \ucc98\ub9ac \ubc29\uc2dd(\uc778\ucf54\ub529)\uc774 \ub2e4\ub974\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ub9cc\uc57d \uc11c\ubc84 \uce21\uc758 \uc778\ucf54\ub529 \ubc29\uc2dd\uc774 UTF8\uc774\ub77c\uba74 \ud074\ub77c\uc774\uc5b8\ud2b8 \uce21\uc758 \uc778\ucf54\ub529\ub3c4 UTF8\ub85c \ubcc0\uacbd\ud574\uc57c \ud569\ub2c8\ub2e4. \ubc29\ubc95\uc740 \ucf58\uc194\uc5d0\uc11c \ub2e4\uc74c\ucc98\ub7fc \uc785\ub825\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<pre>set client_encoding = 'UTF8';<\/pre>\n<p>\uc774\ub807\uac8c \ud558\uace0 \ud55c\uae00 \ub370\uc774\ud130\ub97c \uac00\uc9c4 INSERT \ubb38\uc744 \uc2e4\ud589\ud558\uba74 \uc798\ub4e4\uc5b4\uac11\ub2c8\ub2e4. \uadf8\ub9ac\uace0 SELECT \ubb38\uc744 \ud1b5\ud574 \ud655\uc778\ud574 \ubcf4\uba74 \uc81c\ub300\ub85c&#8230;&#8230;. \uac00 \uc544\ub2cc \ud55c\uae00\uc774 \uae68\uc838 \ubcf4\uc785\ub2c8\ub2e4. <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1110314721.png\" class=\"aligncenter\" width=\"510\" height=\"333\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\ubb50\uac00 \ubb38\uc81c\uc778\uc9c0 \uae30\ubcf8\uc73c\ub85c \ub3cc\uc544\uac00 \uc0dd\uac01\ud574\ubcf4\uba74&#8230; \uba3c\uc800 psql \ucf58\uc194\uc5d0\uc11c SQL \ubb38\uc740 \uc678\ubd80 \ud30c\uc77c\uc744 \ud1b5\ud574 \ub2e4\uc74c\ucc98\ub7fc \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n<pre>\\i c:\/insert.sql<\/pre>\n<p>\uadf8\ub7f0\ub370 \uc774 insert.sql \ud30c\uc77c\uc740 C#\uc73c\ub85c \ub9cc\ub4e0 \uac83\uc774\uace0.. \ud639\uc2dc C#\uc5d0\uc11c \uc774 \ud30c\uc77c\uc744 \uc0dd\uc131\ud560 \ub54c \uc778\ucf54\ub529 \uc9c0\uc815 \ubb38\uc81c\ub85c \uc0dd\uac01\ud558\uc5ec UTF8\ub85c\ub3c4 \ud574\ubcf4\uace0 EUC-KR\ub85c\ub3c4 \uc778\ucf54\ub529 \ud574\ubcf4\uc558\uc73c\ub098 \ubaa8\ub450 \uae68\uc9c0\uace0.. \uc5ec\ucc28 \uc800\ucc28 \uacb0\uad6d \uc778\ucf54\ub529 \uc5c6\uc774(\uadf8\ub7fc \uc774\uac74 \uc5b4\ub5a4 \uc778\ucf54\ub529\uc774\uc9c0?) \uadf8\ub0e5 \uc800\uc7a5\ud558\ub3c4\ub85d \ub2e4\uc2dc \uc6d0\ubcf5\ud558\uace0 GUI \ud234\uc778 pgAdmin\uc5d0\uc11c \ud574\ub2f9 \ub370\uc774\ud130\ub97c \ubcf4\ub2c8 \ud55c\uae00\uc774 \uc54a\uae68\uc838 \uc788\uc2b5\ub2c8\ub2e4. <br \/><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1341497626.png\" class=\"aligncenter\" width=\"510\" height=\"290\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" \/><br \/>\uacb0\ub860\uc740 \ud55c\uae00\uc774 \uc81c\ub300\ub85c \uc800\uc7a5\ub41c \uac83\uc774\uace0 \ucf58\uc194\uc5d0\uc11c \ud55c\uae00\uc774 \uae68\uc838 \ud45c\uc2dc\ub418\ub294 \uac83\uc774\uc600\uc2b5\ub2c8\ub2e4. \uc77c\ub2e8 Windows\uc5d0\uc11c\ub294 \ud55c\uae00 \ub370\uc774\ud130 \uc800\uc7a5\uc740 \ub418\uc5c8\ub294\ub370.. \uc2e4\uc81c \uad6c\ub3d9\uc740 \ub9ac\ub205\uc2a4\uc5d0\uc11c \ud558\ub294\ub370 \uac70\uae30\uc5d0\ub3c4 \ub610 \ub2e4\ub978 \ud55c\uae00 \ubb38\uc81c\uac00 \ud750\ubb3c \ud750\ubb3c \uae30\ub2e4\ub9ac\uace0 \uc788\uc744 \ub4ef \ud55c\ub370.. \uac71\uc815\uc785\ub2c8\ub2e4.. \uc77c\ub2e8 \uc791\uc5c5\uc740 Windows\uc5d0\uc11c \ud558\uace0.. \ucd5c\uc885 \ubc30\ud3ec\uc5d0\uc11c \ub098\ud0c0\ub0a0 \ud55c\uae00 \uad34\ubb3c \ubcf4\uc2a4\uc5d0\uac8c \ube4c\uc5b4\uc57c \uaca0\ub124\uc694&#8230;<\/p>\n<p>\ucc38\uace0\ub85c psql\uc758 \ucd9c\ub825\uacb0\uacfc\ub97c \ud30c\uc77c\ub85c \ub0b4\ubcf4\ub0b4\uae30 \uc704\ud574\uc11c \ub2e4\uc74c \uba85\ub839\uc744 \uc218\ud589\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<pre>\\o c:\/log.txt<\/pre>\n<p>\uc774\ub54c psql\uc744 \uad00\ub9ac\uc790 \uad8c\ud55c\uc73c\ub85c \uc2e4\ud589\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>postgreSQL\uc758 \ucf58\uc194\uc778 psql\uc5d0\uc11c \uc9c1\uc811 SQL\ubb38\uc744 \ub358\uc838\uc11c \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uace0 \ub370\uc774\ud130\ub97c INSERT\ud560\ub54c \ud55c\uae00 \ub370\uc774\ud130\uc5d0\uc11c INSERT \ubb38\uc758 \uc2e4\ud589 \uc870\ucc28 \ub418\uc9c0 \uc54a\ub294 \ubb38\uc81c\ub294 postgreSQL\uc5d0 \ub300\ud55c \uc11c\ubc84 \uce21\uacfc \ud074\ub77c\uc774\uc5b8\ud2b8 \uce21\uc758 \ud55c\uae00 \ucc98\ub9ac \ubc29\uc2dd(\uc778\ucf54\ub529)\uc774 \ub2e4\ub974\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ub9cc\uc57d \uc11c\ubc84 \uce21\uc758 \uc778\ucf54\ub529 \ubc29\uc2dd\uc774 UTF8\uc774\ub77c\uba74 \ud074\ub77c\uc774\uc5b8\ud2b8 \uce21\uc758 \uc778\ucf54\ub529\ub3c4 UTF8\ub85c \ubcc0\uacbd\ud574\uc57c \ud569\ub2c8\ub2e4. \ubc29\ubc95\uc740 \ucf58\uc194\uc5d0\uc11c \ub2e4\uc74c\ucc98\ub7fc \uc785\ub825\ud558\uba74 \ub429\ub2c8\ub2e4. set client_encoding = &#8216;UTF8&#8217;; \uc774\ub807\uac8c \ud558\uace0 \ud55c\uae00 \ub370\uc774\ud130\ub97c &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1928\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;psql\uc5d0\uc11c INSERT \ubb38 \uc2e4\ud589\uc2dc \ud55c\uae00 \ubb38\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":[8],"tags":[],"class_list":["post-1928","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\/1928","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=1928"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1928\/revisions"}],"predecessor-version":[{"id":2918,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1928\/revisions\/2918"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1928"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}