{"id":62,"date":"2010-04-17T21:42:18","date_gmt":"2010-04-18T06:42:18","guid":{"rendered":"\/blog\/?p=62"},"modified":"2023-09-21T09:41:20","modified_gmt":"2023-09-21T00:41:20","slug":"postgresql-%ed%94%84%eb%a1%9c%ea%b7%b8%eb%9e%98%eb%b0%8d","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=62","title":{"rendered":"PostgreSQL \ud504\ub85c\uadf8\ub798\ubc0d"},"content":{"rendered":"\n
\n
\n

Postgresql \ud504\ub85c\uadf8\ub798\ubc0d<\/FONT><\/A><\/H1>\n

\uc724 \uc0c1\ubc30<\/FONT><\/A><\/H3>\n
\n
\n

dreamyun@yahoo.co.kr
 <\/FONT><\/P><\/DIV><\/DIV>\n

\n<\/FONT><\/DIV>\n
\n
\n
\ucc28\ub840<\/B> <\/FONT>\n
1\uc808. <\/FONT>Postgresql \uc5d0 \ub300\ud55c \uc18c\uac1c<\/FONT><\/A> <\/FONT>\n
2\uc808. <\/FONT>Postgresql \ud504\ub85c\uadf8\ub798\ubc0d<\/FONT><\/A> <\/FONT>\n
\n
\n
2.1\uc808. <\/FONT>Postgresql \uc124\uce58\ud558\uae30<\/FONT><\/A> <\/FONT>\n
\n
\n
2.1.1\uc808. <\/FONT>\ub2e4\uc6b4\ubc1b\uae30<\/FONT><\/A> <\/FONT>\n
2.1.2\uc808. <\/FONT>\ucef4\ud30c\uc77c \ud558\uae30<\/FONT><\/A> <\/FONT>\n
2.1.3\uc808. <\/FONT>\ud658\uacbd\uc124\uc815<\/FONT><\/A> <\/FONT>\n
2.1.4\uc808. <\/FONT>\uc11c\ubc84\uc2e4\ud589<\/FONT><\/A><\/DT><\/DL>\n
2.2\uc808. <\/FONT>\ud504\ub85c\uadf8\ub7a8 \uc81c\uc791<\/FONT><\/A> <\/FONT>\n
\n
\n
2.2.1\uc808. <\/FONT>\ud14c\uc2a4\ud2b8\uc6a9 DB \ub9cc\ub4e4\uae30<\/FONT><\/A> <\/FONT>\n
2.2.2\uc808. <\/FONT>\uc5b4\ub5a4 \ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4\uac83\uc778\uac00<\/FONT><\/A> <\/FONT>\n
2.2.3\uc808. <\/FONT>libpq (C library)<\/FONT><\/A> <\/FONT>\n
\n
\n
2.2.3.1\uc808. <\/FONT>DB \uc5f0\uacb0\/\ud574\uc81c\uad00\ub828<\/FONT><\/A> <\/FONT>\n
2.2.3.2\uc808. <\/FONT>\ucffc\ub9ac\uc2e4\ud589 \uad00\ub828<\/FONT><\/A> <\/FONT>\n
2.2.3.3\uc808. <\/FONT>select \ucffc\ub9ac \uacb0\uacfc \uc815\ubcf4\ub97c \uac00\uc838\uc624\uae30<\/FONT><\/A> <\/FONT>\n
2.2.3.4\uc808. <\/FONT>select \uacb0\uacfc \uac00\uc838\uc624\uae30<\/FONT><\/A> <\/FONT>\n
2.2.3.5\uc808. <\/FONT>non select \uacb0\uacfc \uc815\ubcf4 \uac00\uc838\uc624\uae30<\/FONT><\/A><\/DT><\/DL><\/DD><\/DL>\n
2.3\uc808. <\/FONT>\uc608\uc81c<\/FONT><\/A><\/DT><\/DL>\n
3\uc808. <\/FONT>\uacb0\ub860<\/FONT><\/A><\/DT><\/DL><\/DIV>\n
\n
\n<\/FONT>\n

1\uc808. Postgresql \uc5d0 \ub300\ud55c \uc18c\uac1c<\/FONT><\/A><\/H1>\n

Postgresql(\uc774\ud558 Psql)\uc740 Mysql \uacfc \ud568\uaed8 \uacf5\uac1c\uc9c4\uc601\uc5d0\uc11c \uac00\uc7a5 \uc0ac\ub791\ubc1b\uace0 \uc788\ub294 \ub300\ud45c\uc801\uc778 RDBMS \uc774\ub2e4. \uc0c1\ub2f9\ud788 \uc624\ub798\ub41c \uc5ed\uc0ac\ub97c \uac00\uc9c0\uace0 \uc788\uc73c\uba70, \uc644\uc131\ub3c4 \uc5ed\uc2dc \uc0c1\ub2f9\ud788 \ub192\ub2e4. \uc18d\ub3c4\ub97c \uc911\uc694\uc2dc\ud574\uc11c \uba87\uac00\uc9c0 \ud45c\uc900\uc801\uc778 \uae30\ub2a5\uc744 \uc81c\uc678\uc2dc\ud0a8 MySql \uacfc\ub294\ub2ec\ub9ac, Psql \uc740 SQL92 \uc758 \ubaa8\ub4e0 \ud45c\uc900\uc744 \uc9c0\ud0a4\uace0 \uc788\ub2e4. <\/FONT><\/P>\n

\uadf8\ub7f0\uc774\uc720\ub85c \uc911\uaddc\ubaa8\uc11c \ub300\uaddc\ubaa8 \uc0ac\uc774\uc758 \ub370\uc774\ud0c0\ub97c \uc720\uc9c0\ud558\uace0 \uad00\ub9ac\ud558\ub294\ub370 \uc720\uc6a9\ud558\uac8c \uc4f0\uc77c\uc218 \uc788\ub2e4. <\/FONT><\/P>\n

\ub610\ud55c \uacf5\uac1c\uc774\uba74\uc11c\ub3c4 SQL92 \ud45c\uc900\uc744 \uc900\uc218\ud558\uba70, \ube44\uad50\uc801 \uc27d\uac8c \uc811\uadfc\uac00\ub2a5\ud558\ub2e4\ub294 \uc774\uc720\ub54c\ubb38\uc5d0 \uad50\uc721\uc6a9\uc73c\ub85c\uc368\uc758 \uc6a9\ub3c4\ub85c\ub3c4 \ud6cc\ub96d\ud558\uac8c \uc0ac\uc6a9\ud560\uc218 \uc788\uc73c\uba70, \uadf8\ub7f0\uc774\uc720\ub85c \ud544\uc790\uc758 \uacbd\uc6b0 SQL \uc744 \ubc30\uc6b0\uae30 \uc704\ud55c\ud234(\uad50\uc721\uc6a9)\ub85c mysql \ubcf4\ub2e4\ub294 Psql \uc744 \ucd94\ucc9c\ud55c\ub2e4. psql \uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 <\/FONT>PostGreSQL \uc0ac\uc774\ud2b8<\/FONT><\/A> \uc640 <\/FONT>DB \uc0ac\ub791\ub137<\/FONT><\/A> \uc744 \ucc38\uace0\ud558\uae30 \ubc14\ub780\ub2e4. <\/FONT><\/P><\/DIV>\n

\n
\n<\/FONT>\n

2\uc808. Postgresql \ud504\ub85c\uadf8\ub798\ubc0d<\/FONT><\/A><\/H1>\n
\n

2.1\uc808. Postgresql \uc124\uce58\ud558\uae30<\/FONT><\/A><\/H2>\n

\ubcf4\ud1b5 \ud544\uc790\uc758 \uae30\uc0ac\ub294 \ud504\ub85c\uadf8\ub798\ubc0d \uc790\uccb4\uc5d0 \ucd1b\uc810\uc744 \ub9de\ucd94\uace0, \uadf8 \ud658\uacbd\uc744 \ub9cc\ub4dc\ub294 \uac83\uc5d0 \ub300\ud574\uc11c\ub294 \ub2e4\ub8e8\uace0 \uc788\uc9c0 \uc54a\uc9c0\ub9cc, \ud2b9\ubcc4\ud788 Pgsql \uc5d0 \ub300\ud574\uc11c\ub294 \uc124\uce58\ud558\ub294\uac83\uacfc \ud658\uacbd\ub9cc\ub4dc\ub294 \uac83\uae4c\uc9c0 \ub2e4\ub8f0\uac83\uc774\ub2e4. \uc774\uc720\ub294 \uac1c\uc778\uc801\uc73c\ub85c Pgsql \uc744 \ubb34\ucc99 \uc88b\uc544\ud558\uae30 \ub54c\ubb38\uc774\ub2e4. <\/FONT><\/P>\n

\n
\n<\/FONT>\n

2.1.1\uc808. \ub2e4\uc6b4\ubc1b\uae30<\/FONT><\/A><\/H3>\n

\uc774 \uae00\uc5d0\uc11c\ub294 source \ud30c\uc77c\uc744 \uc774\uc6a9\ud55c \uc124\uce58\ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \ub2e4\ub8f0\uac83\uc774\ub2e4. \uba3c\uc81c <\/FONT>http:\/\/www.ca.postgresql.org\/ftpsite<\/FONT><\/A> \uc5d0\uc11c \ucd5c\uc2e0\ubc84\uc83c\uc758 psql \uc744 \ub2e4\uc6b4\ubc1b\ub3c4\ub85d \ud55c\ub2e4. \ucd5c\uc2e0\ubc84\uc83c\uc778 postgresql-7.2.2.tar.gz \ub97c \ub2e4\uc6b4\ubc1b\ub3c4\ub85d \ud558\uc790. <\/FONT><\/P>\n

\ub2e4\uc6b4\ubc1b\uc558\ub2e4\uba74 \uc801\ub2f9\ud55c \ub514\ub809\ud1a0\ub9ac\ub85c \uc62e\uaca8\uc11c \uc555\ucd95\uc744 \ud480\ub3c4\ub85d \ud55c\ub2e4. Linux \uc5d0\uc11c\ub294 \uad00\ub840\uc801\uc73c\ub85c \uc3d8\uc4f0\ud30c\uc77c\uc758 \ucef4\ud30c\uc77c\uc740 \/usr\/src \uc5d0\uc11c \ud55c\ub2e4. <\/FONT><\/P>\n\n\n\n
[root@localhost src]# tar -xvzf postgresql-7.2.2.tar.gz .... .... <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P><\/DIV>\n

\n
\n<\/FONT>\n

2.1.2\uc808. \ucef4\ud30c\uc77c \ud558\uae30<\/FONT><\/A><\/H3>\n

\uc77c\ubc18\uc801\uc778 .\/configure \uc2a4\ud06c\ub9bd\ud2b8\uc2e4\ud589 -> make -> make install-> \ub97c \ub530\ub978\ub2e4. <\/FONT><\/P>\n

\uc6b0\uc120 .\/configure \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc774\uc6a9\ud574\uc11c \uc790\uae30 \ud658\uacbd\uc5d0 \ub9de\ub3c4\ub85d Makefile \uc744 \uc0dd\uc131\uc2dc\ucf1c\uc918\uc57c \ud55c\ub2e4. .\/configure \ub97c \uc2e4\ud589\ud560\ub54c \uc5ec\ub7ec\uac00\uc9c0 \uc635\uc158\uc744 \uc90c\uc73c\ub85c\uc368 pgsql \uc758 \ud658\uacbd\uc5d0 \ubcc0\ud654\ub97c \uc904\uc218 \uc788\ub294\ub370, \uae30\ubcf8\uc801\uc73c\ub85c \uba40\ud2f0\ubc14\uc774\ud2b8\ub97c \uc9c0\uc6d0\ud560\uc218 \uc788\uc5b4\uc57c \ud558\uba70, odbc \uc9c0\uc6d0\uacfc, perl, python, c++ \ub4f1\uc744 \uc704\ud55c \ud504\ub85c\uadf8\ub798\ubc0d \uc778\ud14c\ud398\uc774\uc2a4\ub97c \uc9c0\uc6d0\ud558\ub3c4\ub85d \ub9cc\ub4e4\uac83\uc774\ub2e4. \uadf8\ub7ec\ubbc0\ub85c \ub300\ucda9 \uc544\ub798\uc640 \uac19\uc740 \uc2a4\ud06c\ub9bd\ud2b8 \uc2e4\ud589\ud654\uba74\uc744 \ubcf4\uc5ec\uc904\uac83\uc774\ub2e4. <\/FONT><\/P>\n\n\n\n
[root@localhost src]# .\/configure --enable-multibyte --enable-locale \\ > --enable-nls=ko --with-CXX --with-python --enable-odbc ... ... <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\uc774\uc81c Makefile \uc774 \ub9cc\ub4e4\uc5b4\uc84c\uc744\uac83\uc774\ub2e4. \uadf8\ub7fc make \ub97c \uc774\uc6a9\ud574\uc11c \uc3d8\uc4f0\ub97c \ucef4\ud30c\uc77c \ud558\ub3c4\ub85d \ud55c\ub2e4. \uc644\ub8cc\ub418\uc5c8\ub2e4\uba74 make install \uc744 \uc774\uc6a9\ud574\uc11c \uc124\uce58\ub97c \uc885\ub8cc\ud55c\ub2e4. <\/FONT><\/P>\n

 <\/P><\/DIV>\n

\n
\n<\/FONT>\n

2.1.3\uc808. \ud658\uacbd\uc124\uc815<\/FONT><\/A><\/H3>\n

\uc124\uce58\ub97c \ub9c8\ucce4\ub2e4\uba74 pgsql \uc744 \uac00\ub3d9\uc2dc\ud0a4\uae30 \uc704\ud55c \uba87\uac00\uc9c0 \ud658\uacbd\uc124\uc815\uc744 \ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4. <\/FONT><\/P>\n

RDBMS \uc11c\ubc84\ub97c root \ub85c \uc2e4\ud589\uc2dc\ud0ac\uacbd\uc6b0 \uc5ec\ub7ec\uac00\uc9c0 \ubcf4\uc548\ubb38\uc81c\ub4f1\uc744 \uc77c\uc73c\ud0ac\uc218 \uc788\uc74c\uc73c\ub85c, pgsql \uc740 \uc774\ub97c \uc6d0\ucc9c\uc801\uc73c\ub85c \ubd09\uc1c4\ud558\uace0 \uc788\ub2e4. \ubc18\ub4dc\uc2dc DB\uad00\ub9ac\ub97c \uc704\ud658 \uc77c\ubc18\uc720\uc800\ub97c \ud558\ub098 \uc0dd\uc131\ud55c\ub2e4\uc74c\uc5d0, \uc774 \uc720\uc800\ub97c \ud1b5\ud574\uc11c \uc11c\ubc84\uad00\ub9ac\ub97c \ud574\uc57c\ub9cc \ud55c\ub2e4. \uc77c\ubc18\uc720\uc800\ub97c \ud558\ub098 \ub9cc\ub4e4\ub3c4\ub85d \ud558\uc790 \uc774\ub984\uc740 \uad00\ub9ac\uc790 \ub9c8\uc74c\uc778\ub370, \ud544\uc790\ub294 postgres \uc774\ub984\uc73c\ub85c \ub9cc\ub4e4\uc5c8\ub2e4. <\/FONT><\/P>\n\n\n\n
[root@localhost src]# adduser postgres [root@localhost src]# passwd postgres Changing password for user postgres New UNIX password: ... <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

\uc720\uc800 \uc0dd\uc131\uc744 \ud574\uc8fc\uc5c8\ub2e4\uba74 \uc774\uc81c\ub294 pgsql \uc774 \ub370\uc774\ud0c0\ub4e4\uc744 \uad00\ub9ac\ud560 (\ud14c\uc774\ube14\uacfc, \ud14c\uc774\ube14\ub0b4\uc6a9\ub4e4\uc774 \ud30c\uc77c\ub85c \uc815\ub9ac\ub418\ub294) \ub514\ub809\ud1a0\ub9ac\ub97c \ub9cc\ub4e4\uc5b4\uc8fc\uace0 \uc774 \ub514\ub809\ud1a0\ub9ac\uc5d0 \ub300\ud55c \uad8c\ud55c \uc124\uc815\uc744 \ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4. <\/FONT><\/P>\n

\uc6b0\ub9ac\ub294 pgsql \uc744 \ucef4\ud30c\uc77c\ud560\uc801\uc5d0 \uc5b4\ub514\uc5d0 \uc124\uce58\ub420\uc9c0 \ub514\ub809\ud1a0\ub9ac\ub97c \uc9c0\uc815\ud574 \uc8fc\uc9c0 \uc54a\uc558\ub2e4. \uc774\ub7f4\uacbd\uc6b0\uc5d0\ub294 \uae30\ubcf8\ub514\ub809\ud1a0\ub9ac\ub85c \uc124\uc815\ub418\ub294\ub370, \uae30\ubcf8 \ub514\ub809\ud1a0\ub9ac\ub294 \/usr\/local\/pgsql \uc774\ub2e4. \uadf8\ub7ec\ub2c8 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \ud30c\uc77c\uc774 \uc313\uc774\ub294 \ub514\ub809\ud1a0\ub9ac\ub294 \/usr\/local\/pgsql\/data \ub85c \ud558\ub3c4\ub85d \ud558\uaca0\ub2e4. \ub514\ub809\ud1a0\ub9ac\ub97c \ub9cc\ub4e0\ub2e4\uc74c\uc5d0 \uc18c\uc720\uc790\ub97c postgres \ub85c \ud574\uc8fc\uace0, \ubcf4\uc548\uc744 \uc704\ud574\uc11c \uad8c\ud55c\uc744 700 \uc73c\ub85c \ud558\ub3c4\ub85d \ud558\uc790. <\/FONT><\/P>\n\n\n\n
[root@localhost src]# mkdir \/usr\/local\/pgsql\/data [root@localhost src]# chown postgres.postgres \/usr\/local\/pgsql\/data [root@localhost src]# chmod 700 \/usr\/local\/pgsql\/data <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

\ub9cc\ub4e4\uc5b4\uc9c4 postgres \uc720\uc800\ub85c \ubcc0\uacbd\ud55c\ub2e4\uc74c\uc5d0, DB \uad00\ub9ac\uc790\ub85c\uc368 \ud544\uc694\ud55c \ud658\uacbd\uc124\uc815\uc744 \ud558\ub3c4\ub85d \ud558\uc790. <\/FONT><\/P>\n

\uc6b0\uc120\uc740 \uc2e4\ud589\ud30c\uc77c \uacbd\ub85c\ub97c \uc9c0\uc815\ud574\uc918\uc57c \ud55c\ub2e4. \uc2e4\ud589\ud30c\uc77c\uc740 \/usr\/local\/pgsql\/bin \uc774\ub2e4. \".bash_profile\" \uc744 \ud3b8\uc9d1\ud574\uc11c \uc2e4\ud589\ud30c\uc77c \ucc3e\uae30 \uacbd\ub85c, \ub77c\uc774\ube0c\ub7ec\ub9ac \ucc3e\uae30\uacbd\ub85c\ub97c \uc9c0\uc815\ud574 \uc8fc\uc5b4\uc57c \ud55c\ub2e4. <\/FONT><\/P>\n\n\n\n
PATH=$PATH:\/usr\/local\/pgsql\/bin LD_LIBRARY_PATH=$LD_LIBRARY_PATH:\/usr\/local\/pgsql\/lib export LD_LIBRARY_PATH PATH <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

.bash_profile \ub97c \uc218\uc815\ud588\ub2e4\uba74, \ub2e4\uc2dc \ub85c\uadf8\uc778\uc744 \ud558\ub358\uc9c0, source \uba85\ub839\uc744 \uc774\uc6a9\ud574\uc11c \ud658\uacbd\ubcc0\uc218\ub97c \ub2e4\uc2dc \ub4f1\ub85d\uc2dc\ud0a4\ub3c4\ub85d \ud558\uc790. <\/FONT><\/P>\n\n\n\n
[root@localhost test]# source \/root\/.bash_profile <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P><\/DIV>\n

\n
\n<\/FONT>\n

2.1.4\uc808. \uc11c\ubc84\uc2e4\ud589<\/FONT><\/A><\/H3>\n

\uc11c\ubc84 \uc2e4\ud589\uc744 \uc704\ud574\uc11c\ub294 root \uac00 \uc544\ub2cc \uc77c\ubc18\uacc4\uc815\uc790\ub85c \ubcc0\ud658\ud574\uc57c \ud55c\ub2e4. DB \uad00\ub9ac\uc790\ub97c \uc704\ud574\uc11c postgres \ub97c \ub9cc\ub4e4\uc5b4 \ub450\uc5c8\uc73c\ub2c8 postgres \ub85c \uc720\uc800 \ubcc0\uacbd\ud558\ub3c4\ub85d \ud55c\ub2e4. <\/FONT><\/P>\n\n\n\n
[root@localhost src]# su - postgres <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

\uc2a4\uc704\uce6d \uc720\uc800\ub97c \ud588\ub2e4\uba74 DB \ucd08\uae30\ud654\ub97c \ud574\uc57c\ud55c\ub2e4. DB \ucd08\uae30\ud654\ub77c\uace0 \ud574\uc11c \uba38 \uac70\ucc3d\ud558\uac8c \uc5b4\ub824\uc6b8\uac83\uc73c\ub85c \uc0dd\uac01\ud560 \ud544\uc694 \uc5c6\ub2e4. \uadf8\ub0e5 initdb \ub97c \ud55c\ubc88\ub9cc \uc2e4\ud589\uc2dc\ucf1c\uc8fc\uba74 \ub41c\ub2e4. <\/FONT><\/P>\n\n\n\n
[postgres@localhost src]$ initdb .... ... Success. You can now start the database server using: \/usr\/local\/pgsql\/bin\/postmaster -D \/usr\/local\/pgsql\/data or \/usr\/local\/pgsql\/bin\/pg_ctl -D \/usr\/local\/pgsql\/data -l logfile start [postgres@localhost src]$ postmaster -i& <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\uadf8\ub2e4\uc74c\uc5d0 postmaster \ub97c \uc774\uc6a9\ud574\uc11c \uc11c\ubc84\ub97c \ub744\uc6b0\uba74 \ub41c\ub2e4. \uc774\ub54c \uc778\ud130\ub137 \uc11c\ube44\uc2a4\ub97c \uac00\ub2a5\ud558\uac8c \ud558\uace0 \uc2f6\ub2e4\uba74 \"-i\" \uc635\uc158\uc744 \uc918\uc57c \ud55c\ub2e4. <\/FONT><\/P>\n

 <\/P><\/DIV><\/DIV>\n

\n
\n<\/FONT>\n

2.2\uc808. \ud504\ub85c\uadf8\ub7a8 \uc81c\uc791<\/FONT><\/A><\/H2>\n

\uc774\uc81c psql \uc758 \uc124\uce58\ub97c \ub9c8\ucce4\uc74c\uc73c\ub85c pgsql \uc5d0\uc11c \uc81c\uacf5\ud558\ub294 c\/c++ API \ub97c \uc774\uc6a9\ud574\uc11c \ud504\ub85c\uadf8\ub798\ubc0d\uc744 \ud574\ubcf4\uae30\ub85c \ud558\uc790. <\/FONT><\/P>\n

\n
\n<\/FONT>\n

2.2.1\uc808. \ud14c\uc2a4\ud2b8\uc6a9 DB \ub9cc\ub4e4\uae30<\/FONT><\/A><\/H3>\n

\ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4\ub824\uba74 \ubb34\uc5b8\uac00 \uc5d1\uc138\uc2a4\uac00 \uac00\ub2a5\ud55c \uc790\ub8cc\uac00 \uc788\uc5b4\uc57c \ud560\uac83\uc774\ub2e4. <\/FONT><\/P>\n

\uc774\ubc88 \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc0ac\uc6a9\ub420 DB\uc815\ubcf4\ub294 \uc6b0\ud3b8\ubc88\ud638\ub85c \ud558\uae30\ub85c \ud558\uaca0\ub2e4. \uc6b0\ud3b8\ubc88\ud638 \ub370\uc774\ud0c0\ub294 <\/FONT>Kylix3 \ub97c \uc774\uc6a9\ud55c \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc81c\uc791<\/FONT><\/A> \uc5d0\uc11c \uc774\uc6a9\ud574\ub358\ub370\uc774\ud0c0\ub97c \uc81c\uc0ac\uc6a9\ud558\ub3c4\ub85d \ud558\uaca0\ub2e4. <\/FONT><\/P>\n

\uba3c\uc81c createdb \ub97c \uc774\uc6a9\ud574\uc11c post \ub77c\ub294 \uc774\ub984\uc758 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c \ub9cc\ub4e4\ub3c4\ub85d \ud558\uc790. <\/FONT><\/P>\n\n\n\n
[postgres@localhost src]$ createdb post CREATE DATABASE <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\uadf8\ub2e4\uc74c\uc5d0 \uc6b0\ud3b8\ubc88\ud638 \ub370\uc774\ud0c0\ub97c \uc785\ub825\ud574\uc57c \ud560\uac74\ub370, \uc774\uac83\uc740 \uc704\uc758 kylix3 \ub97c \uc774\uc6a9\ud55c \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \uc81c\uc791\uc758 \ubb38\uc11c\ub97c \ucc38\uace0\ud558\uae30 \ubc14\ub780\ub2e4. <\/FONT><\/P>\n

 <\/P><\/DIV>\n

\n
\n<\/FONT>\n

2.2.2\uc808. \uc5b4\ub5a4 \ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4\uac83\uc778\uac00<\/FONT><\/A><\/H3>\n

\ub9cc\ub4e4 \ud504\ub85c\uadf8\ub7a8\uc740 \"Kylix3 \ub97c \uc774\uc6a9\ud55c \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \uc81c\uc791\" \uc5d0\uc11c \ub9cc\ub4e0 GUI \ubc84\uc83c\uc758 \ud504\ub85c\uadf8\ub7a8\uc744 pgsql \uc5d0\uc11c \uc81c\uacf5\ud558\ub294 C API \ub97c \uc774\uc6a9\ud574\uc11c \uc81c\uc791\uc131\ud55c \ud504\ub85c\uadf8\ub7a8\uc73c\ub85c, \ub2e8\uc21c\ud788 \ub9ac\uc2a4\ud2b8\ub9cc \ubcf4\uc5ec\uc8fc\ub294 \ub370\uc5d0\uc11c \ud0c8\ud53c\ud558\uc5ec \uc0ac\uc6a9\uc790\uac00 \uc6d0\ud558\ub294 \uc9c0\uc5ed\uc758 \uc6b0\ud3b8\ubc88\ud638\ub97c \ucc3e\uc744\uc218 \uc788\ub3c4\ub85d \uc778\ud130\ud398\uc774\uc2a4\ub3c4 \uc81c\uacf5\ud560\uac83\uc774\ub2e4. <\/FONT><\/P>\n

\uadf8\ub807\uc9c0\ub9cc \uc644\ubcbd\ud55c \ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4\uc9c0\ub294 \uc54a\uc744\uac83\uc774\ub2e4. \ub2e8\uc9c0 \uc774\ub7f0\uc2dd\uc73c\ub85c pgsql API \ub97c \uc774\uc6a9\ud574\uc11c \ud504\ub85c\uadf8\ub7a8\uc81c\uc791\uc774 \uac00\ub2a5\ud558\ub2e4 \ub77c\ub294 \uc815\ub3c4\ub9cc\uc744 \ubcf4\uc5ec\uc8fc\ub294 \uc218\uc900\uc73c\ub85c \uc81c\uc791\ud558\uac8c \ub420\uac83\uc774\ub2e4. <\/FONT><\/P><\/DIV>\n

\n
\n<\/FONT>\n

2.2.3\uc808. libpq (C library)<\/FONT><\/A><\/H3>\n

pgsql \uc740 C \ud504\ub85c\uadf8\ub798\ubc0d \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc704\ud55c libpq C \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \uc81c\uacf5\ud55c\ub2e4. \uc774 \ub77c\uc774\ube0c\ub7ec\ub9ac\uc758 \uc704\uce58\ub294 \/usr\/local\/pgsql\/lib \uc5d0 \uc704\uce58\ud558\uace0 \uc788\ub2e4. \uc774\ubc88\uc7a5\uc5d0\uc11c\ub294 libpq \uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uae30\ubcf8\uc801\uc778 \uba87\uac00\uc9c0 \ud568\uc218\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcfc \uac83\uc774\ub2e4. <\/FONT><\/P>\n

\uadf8\ub807\uc9c0\ub9cc \ubaa8\ub4e0 \ud568\uc218\uc5d0 \ub300\ud574\uc11c \uc124\uba85\uc744\ud558\uc9c4 \uc54a\uc744\uac83\uc774\uba70, \ub2e8\uc9c0 \uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 \uc911\uc694\ud55c \uba87\uba87\ud568\uc218\uc5d0 \uc6b0\uc120\uc21c\uc704\ub97c \ub450\uace0 \uc124\uba85\ud560\uac83\uc774\ub2e4. \ub2e4\ub978 \uc5ec\ub7ec\uac00\uc9c0 \ud568\uc218\ub4e4\uc5d0 \ub300\ud574\uc11c \uc54c\uace0 \uc2f6\ub2e4\uba74 \/usr\/local\/pgsql\/doc\/html \uc544\ub798\uc5d0 \uc788\ub294 html \ubb38\uc11c\ub4e4\uc744 \ucc38\uace0\ud558\uae30 \ubc14\ub780\ub2e4. <\/FONT><\/P>\n

\n
\n<\/FONT>\n

2.2.3.1\uc808. DB \uc5f0\uacb0\/\ud574\uc81c\uad00\ub828<\/FONT><\/A><\/H4>\n

DB\uc5f0\uacb0\uacfc \uad00\ub828\ub418\uc5b4\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 2\uac00\uc9c0\uc758 \uc911\uc694\ud55c \ud568\uc218\ub4e4\uc774 \uc81c\uacf5\ub41c\ub2e4. <\/FONT><\/P>\n\n\n\n
#include <libpq-fe.h> PGconn *<\/FONT>PQsetdb<\/FONT><\/A>(char *pghost, char *pgport, char *pgoptions, char *pgtty, char *dbName); PGconn *PQsetdbLogin(char *pghost, char *pgport, char *pgoptions, char *pgtty, char *dbName, char *login, char *pwd); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

2\uac1c \ud568\uc218\ub294 \uac19\uc740\uc77c\uc744 \ud55c\ub2e4. \ub2e4\ub9cc Login \uc774 \ubd99\uc740 \ud568\uc218\uc758 \uacbd\uc6b0 \uad8c\ud55c\uc744 \ud68d\ub4dd\ud558\uae30 \uc704\ud574\uc11c \ub85c\uae34\uc774\ub984\uacfc \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud574\uc57c\ud560 \ud544\uc694\uac00 \uc788\uc744\ub54c \uc0ac\uc6a9\ud55c\ub2e4. <\/FONT><\/P>\n

 <\/P>\n

PQsetdb \uc758 \uacbd\uc6b0\ub294 \uad8c\ud55c\ud68d\ub4dd\uc774 \ud544\uc694 \uc5c6\uc744 \uacbd\uc6b0 \uc608\ub97c \ub4e4\uc790\uba74 \ubaa8\ub450\uc5d0\uac8c \uc5f4\ub9b0 db \ub098 \ud639\uc740 postgres \uc640 \uac19\uc740 DB\uad00\ub9ac\uc790 \uad8c\ud55c\uc744 \uac00\uc9c0\uace0 \uc788\uc744\ub54c \uc0ac\uc6a9\ud560\uc218 \uc788\uc744 \uac83\uc774\ub2e4. <\/FONT><\/P>\n

\ub9ac\ud134\uac12\uc740 DB \uc5f0\uacb0\uc744 \uac00\ub974\ud0a4\ub294 PGconn \uc774\ub77c\ub294 DB \uc5f0\uacb0 \uc815\ubcf4 \uac1d\uccb4\uc774\ub2e4. <\/FONT><\/P>\n

\uc544\uaddc\uba3c\ud2b8\ub294 \uac01\uac01 \uc811\uadfc\ud558\uace0\uc790 \ud558\ub294 \"\ud638\uc2a4\ud2b8\", \"\ud3ec\ud2b8\", \"\uc635\uc158\", \"\ub514\ubc84\uae45\uc6a9 tty\", \"\ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc774\ub984\", \"\ub85c\uae30\uc778 ID\", \"\ud328\uc2a4\uc6cc\ub4dc\" \ub97c \ub098\ud0c0\ub0b8\ub2e4. pgsql \uc740 \ud3ec\ud2b8\ub85c 5432 \ub97c \uc0ac\uc6a9\ud55c\ub2e4. <\/FONT><\/P>\n

\uc5f0\uacb0\uc744 \ud588\ub2e4\uba74 DB \uc5f0\uacb0\uc744 \ub04a\uc5b4\uc8fc\ub294 \ud568\uc218\ub3c4 \uc788\uc5b4\uc57c \ud560\uac83\uc774\ub2e4. <\/FONT><\/P>\n\n\n\n
PQfinish<\/FONT><\/A>(conn); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\uc544\uaddc\uba3c\ud2b8\ub85c\ub294 PQsetdb(\ud639\uc740 PQsetdbLogin)\uc744 \ud1b5\ud574\uc11c \uc5bb\uc740 PGconn \uac12\uc744 \ub123\uc5b4\uc8fc\uba74 \ub41c\ub2e4. <\/FONT><\/P>\n

 <\/P>\n

libpq \ub294 \uac01\uac01\uc758 \ud568\uc218\uc2e4\ud589\uc5d0 \ub300\ud574\uc11c \uadf8\uacb0\uacfc\ub97c \uc54c\uc218 \uc788\ub294 \ubcc4\ub3c4\uc758 \ud568\uc218\ub97c \uc81c\uacf5\ud55c\ub2e4. \uc774\uacbd\uc6b0\uc5d0\ub294 DB\uc5f0\uacb0\uc774 \uc81c\ub300\ub85c \uc774\ub8e8\uc5b4\uc84c\ub294\uc9c0, \uc81c\ub300\ub85c \uc774\ub8e8\uc5b4\uc9c0\uc9c0 \uc54a\uc558\ub2e4\uba74 \uc5b4\ub5a4 \ubb38\uc81c\uac00 \uc788\ub294\uc9c0\ub97c \uc54c\ub824\uc8fc\ub294 \uc5f0\uacb0\uac80\uc0ac \ud568\uc218\ub97c \uc81c\uacf5\ud55c\ub2e4. <\/FONT><\/P>\n\n\n\n
ConnStatusType <\/FONT>PQstatus<\/FONT><\/A>(const PGconn *conn); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\uc608\ub97c\ub4e4\uc5b4\uc11c \uc5f0\uacb0\uc5d0 \ubb38\uc81c\uac00 \uc788\ub294\uc9c0 \ud655\uc778\ud574 \ubcf4\uace0 \uc2f6\ub2e4\uba74 <\/FONT><\/P>\n\n\n\n
if (<\/FONT>PQstatus<\/FONT><\/A>(conn) == CONNECTION_BAD) { fprintf(stderr, \"%s\", <\/FONT>PQerrMessage<\/FONT><\/A>(conn)); <\/FONT>exit<\/FONT><\/A>(0); } <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\uacfc \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \uc5f0\uacb0 \uccb4\ud06c\ub97c \ud560\uc218\uac00 \uc788\ub2e4. <\/FONT><\/P>\n

 <\/P><\/DIV>\n

\n
\n<\/FONT>\n

2.2.3.2\uc808. \ucffc\ub9ac\uc2e4\ud589 \uad00\ub828<\/FONT><\/A><\/H4>\n

\uc5ec\uae30\uc5d0\uc11c\ub294 Query \ub97c \uc2e4\ud589\ud558\uace0 \uadf8 \uac12\uc744 \uac00\uc838\uc624\ub294 \ud568\uc218\ub4e4\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\ub2e4. <\/FONT><\/P>\n

Query \ub97c \uc2e4\ud589\ud558\uae30 \uc704\ud55c \uac00\uc7a5 \uac04\ub2e8\ud55c \ud568\uc218\ub294 PQexec \uc774\ub2e4. <\/FONT><\/P>\n\n\n\n
PGresult *<\/FONT>PQexec<\/FONT><\/A>(PGconn *conn, const char *query); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\uc0ac\uc6a9\ubc29\ubc95\uc740\uac04\ub2e8\ud558\ub2e4. PQsetdb \ub4f1\uc758 \ud568\uc218\ub97c \ud1b5\ud574 \ub118\uaca8\ubc1b\uc740 \uc5f0\uacb0\uc815\ubcf4\ub97c \uccab\ubc88\uc9f8 \uc544\uaddc\uba3c\ud2b8\ub85c \ud558\uace0, 2\ubc88\uc9f8 \uc544\uaddc\uba3c\ud2b8\uc5d0 \uc2e4\ud589\uc2dc\ud0a4\uace0\uc790\ud558\ub294 \ucffc\ub9ac\ub97c \uc785\ub825 \ud558\uba74\ub41c\ub2e4. <\/FONT><\/P>\n

 <\/P>\n

\ub610\ud55c <\/FONT>PQresultStatus<\/FONT><\/A>() \ud568\uc218\ub97c \uc0ac\uc6a9\ud574\uc11c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud55c \uacb0\uacfc\uc5d0 \ub300\ud55c \uc0c1\ud0dc\ub97c \uc54c\uc544\ub0bc\uc218 \uc788\ub2e4. <\/FONT><\/P>\n\n\n\n
ExecStatusType <\/FONT>PQresultStatus<\/FONT><\/A>(const PGresult *res); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\ub2e4\uc74c\uacfc \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \uc54c\uc544\ub0bc\uc218 \uc788\uc744\uac83\uc774\ub2e4. <\/FONT><\/P>\n\n\n\n
\/\/\ucffc\ub9ac\ub97c \uc131\uacf5\uc801\uc73c\ub85c \uc218\ud589\ud574\uc11c \ub370\uc774\ud0c0 \ub0b4\uc6a9\uc744 \uac00\uc838\uc654\ub294\uc9c0
if (PQresultStatus<\/A>(res) != PGRES_TUPLE_OK)
{
}

\/\/ \ube44\uc5b4\uc788\ub294 \ucffc\ub9ac\ub97c \ubcf4\ub0c8\uc744\uacbd\uc6b0
if (PQresultStatus<\/A>(res) != PGRES_EMPTY_QUERY)
{
}

\/\/ \uba85\ub839\uc744 \uc131\uacf5\uc801\uc73c\ub85c \uc218\ud589\ud588\uc744\uacbd\uc6b0
\/\/ \ub2e8 \uc774\uac83\uc740 \ub370\uc774\ud0c0\ub97c \uac00\uc838\uc624\ub294 \ucffc\ub9ac\uac00 \uc544\ub2cc \uba85\ub839\ub4e4\uc5d0 \ub300\ud55c \uacb0\uacfc\ub97c \uc54c\uace0 \uc2f6\uc744\ub54c.
if (PQresultStatus<\/A>(res) != PGRES_COMMAND_OK)
{
}

\/\/ \uce58\uba85\uc801\uc778 \uc624\ub958\uac00 \ubc1c\uc0dd\ud588\uc744\uacbd\uc6b0
\/\/ \ucffc\ub9ac\ub97c \uc798\ubabb\ub0b4\ub838\uac70\ub098, \uc5c6\ub294 \ud14c\uc774\ube14\ub85c \ubd80\ud130 \uc790\ub8cc\ub97c \uc694\uccad\ud558\ub294\ub4f1 ..
if (PQresultStatis<\/A>(res) != PGRES_FATAL_ERROR)
{
}
<\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

\ub610\ud55c <\/FONT>PQresultERRorMessage<\/FONT><\/A>() \ud568\uc218\ub97c \uc774\uc6a9\ud568\uc73c\ub85c\uc368, \ucffc\ub9ac\uc5d0 \ub300\ud574\uc11c \uc815\ud655\ud558\uac8c \uc5b4\ub5a0\ud55c \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud588\ub294\uc9c0\ub97c \uc54c\uc544\ub0bc\uc218 \uc788\ub2e4. <\/FONT><\/P>\n\n\n\n
if (PQresultStatis<\/A>(res) != PGRES_FATAL_ERROR)
{
    fprintf(stderr, \"%s\", PQresultErrorMessage<\/A>(const PGresult *res));
}<\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

\ub354\uc774\uc0c1 \ucffc\ub9ac\uacb0\uacfc \ubc1c\uc0dd\ud55c \ub370\uc774\ud0c0\ub97c \uc0ac\uc6a9\ud560\uc77c\uc774 \uc5c6\ub2e4\uba74, \ubc18\ub4dc\uc2dc <\/FONT>PQclear<\/FONT><\/A>() \ud568\uc218\ub97c \uc774\uc6a9\ud574\uc11c \uba54\ubaa8\ub9ac <\/FONT>\ud574\uc81c<\/FONT><\/A>(free) \uc2dc\ucf1c\uc918\uc57c \ud55c\ub2e4. \ub9cc\uc57d \uadf8\ub807\uc9c0 \uc54a\ub2e4\uba74 \uba54\ubaa8\ub9ac \ub204\uc218\uac00 \uc77c\uc5b4\ub0a0\uc218\ub3c4 \uc788\ub2e4. <\/FONT><\/P>\n\n\n\n
void <\/FONT>PQclear<\/FONT><\/A>(PQresult *res); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P><\/DIV>\n

\n
\n<\/FONT>\n

2.2.3.3\uc808. select \ucffc\ub9ac \uacb0\uacfc \uc815\ubcf4\ub97c \uac00\uc838\uc624\uae30<\/FONT><\/A><\/H4>\n

select \ucffc\ub9ac\ub97c \uc774\uc6a9\ud574\uc11c \ub370\uc774\ud0c0\ub97c \uac00\uc838\uc654\uc744\uacbd\uc6b0, \uba87\uac1c\uc758 \ub370\uc774\ud0c0\ub97c \uac00\uc838\uc654\ub294\uc9c0, \uac00\uc838\uc628 \ub370\uc774\ud0c0\ub294 \uba87\uac1c\uc758 \ud544\ub4dc\ub85c \uc774\ub8e8\uc5b4\uc838 \uc788\ub294\uc9c0, \ub4f1\uc744 \uc54c\uc544\ub0b4\uc57c \ud560\uac83\uc774\ub2e4. <\/FONT><\/P>\n

PQntuples \ub97c \uc774\uc6a9\ud574\uc11c \uc6b0\ub9ac\uac00 \ub0b4\ub9b0 \ucffc\ub9ac\uc758 \uacb0\uacfc\uac12\uc774 \uba87\uac1c\uc778\uc9c0 \uc54c\uc544\ub0bc\uc218 \uc788\ub2e4. <\/FONT><\/P>\n\n\n\n
int <\/FONT>PQntuples<\/FONT><\/A>(const PGresult *res); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

PQnfields \ub97c \uc774\uc6a9\ud574\uc11c \uac00\uc838\uc628 \ub370\uc774\ud0c0\uac00 \uba87\uac1c\uc758 \ud544\ub4dc\ub85c \uc774\ub8e8\uc5b4\uc838 \uc788\ub294\uc9c0 \ud655\uc778\ud560\uc218 \uc788\ub2e4. <\/FONT><\/P>\n\n\n\n
int <\/FONT>PQnfields<\/FONT><\/A>(const PGresult *res); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

\uac01 \ud544\ub4dc\uc758 \ud544\ub4dc\uba85\uc744 \uac00\uc838\uc62c\uc218 \uc788\ub2e4. <\/FONT><\/P>\n\n\n\n
char *<\/FONT>PQfname<\/FONT><\/A>(const PGresult *res, int field_index); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

\uac01\ud544\ub4dc\uac00 \uba87\ubc14\uc774\ud2b8\uc758 \ud06c\uae30\ub97c \ucc28\uc9c0\ud558\uace0 \uc788\ub294\uc9c0 \uc54c\ub824\uc900\ub2e4. \uc989 int \ud615\uc774\ub77c\uba74 4 \ub97c \ub418\ub3cc\ub824\uc904\uac83\uc774\ub2e4. \ub9cc\uc57d \ud544\ub4dc\uac00 variable \ud0c0\uc785\uc774\ub77c\uba74 -1 \uc744 \ub418\ub3cc\ub824\uc904\uac83\uc774\ub2e4. <\/FONT><\/P>\n\n\n\n
int <\/FONT>PQfsize<\/FONT><\/A>(const PGresult *res, int field_index); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P><\/DIV>\n

\n
\n<\/FONT>\n

2.2.3.4\uc808. select \uacb0\uacfc \uac00\uc838\uc624\uae30<\/FONT><\/A><\/H4>\n

\uc774\uc81c select \ud55c \uacb0\uacfc\ub97c \uac00\uc838\uc624\uae30\ub85c \ud558\uc790. PQgetvalue \ub97c \uc774\uc6a9\ud574\uc11c \ucffc\ub9ac \uacb0\uacfc\uc5d0 \ub300\ud55c \uac12\uc744 \uac00\uc838\uc62c\uc218 \uc788\ub2e4. <\/FONT><\/P>\n\n\n\n
int <\/FONT>PQgetvalue<\/FONT><\/A>(const PGresult *res, int tup_num, int field_num); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\uc544\uaddc\uba3c\ud2b8\ub294 PGresult \uac1d\uccb4\uc640, \uac00\uc838\uc624\uace0\uc790 \ud558\ub294 tuple \uc758 \uc778\ud14d\uc2a4 \ubc88\ud638 \uadf8\ub9ac\uace0 \uac00\uc838\uc624\uace0\uc790 \ud558\ub294 field \uc758 index \ubc88\ud638\uc774\ub2e4. \uc778\ub371\uc2a4 \ubc88\ud638\ub294 \ubc30\uc5f4\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c 0\ubc88\ubd80\ud130 \uc2dc\uc791\ud55c\ub2e4. <\/FONT><\/P>\n

 <\/P>\n

\uadf8\ub9ac\uace0 PQgetisnull \ub97c \uc774\uc6a9\ud574\uc11c \ub370\uc774\ud0c0\uac00 \uc788\ub294\uc9c0 \uc5c6\ub294\uc9c0 \ud655\uc778\ud560\uc218 \uc788\ub2e4. <\/FONT><\/P>\n\n\n\n
int <\/FONT>PQgetisnull<\/FONT><\/A>(const PGresut *res, int tup_num, int field_num); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\ub9cc\uc57d tup_num \uc758 field_num \uc5d0 \ud574\ub2f9\ub418\ub294 \ub370\uc774\ud0c0\uac00 \uc5c6\ub2e4\uba74 1\uc744 \ubc18\ud658\ud560\uac83\uc774\ub2e4. \uc774\uac83\uc740 \ud544\ub4dc\uc758 \uac12\uc774 NULL \uc77c\uacbd\uc6b0 1 \uc744 \ub3cc\ub824\uc8fc\uc9c0 \uc54a\ub294\ub2e4\ub294 \uc810\uc744 \uc720\uc758\ud574\uc57c \ud55c\ub2e4. tup_num \uc774 field_num \uc790\uccb4\uac00 \uc5c6\uc744\uacbd\uc6b0, \uc989 \uc798\ubabb\ub41c tuple \uc778\ub371\uc2a4\ubc88\ud638 (tuple \ucd5c\ub300 \ud06c\uae30 \ubc88\ud638\ub97c \ucd08\uacfc\ud588\uc744\uacbd\uc6b0) \ub4f1\uc744 \ucc38\uc870\ud560\uacbd\uc6b0 1 \uc744 \ub3cc\ub824\uc900\ub2e4. \uc774\ub7ec\ud55c \ud2b9\uc131\uc744 \uc0ac\uc6a9\ud574\uc11c PQgetisnull \uc744 \uc0ac\uc6a9\ud574\uc11c, 1\uc774 \ub420\ub54c\uae4c\uc9c0 \uacc4\uc18d \uc99d\uac00\uc2dc\ud0a4\uba74\uc11c \uc6d0\ud558\ub294 \ub370\uc774\ud0c0\ub97c \uac00\uc838\uc62c\uc218 \uc788\uc744\uac83\uc774\ub2e4. <\/FONT><\/P>\n\n\n\n
int i = 0; ... while(PQgetisnull(res, i, 0) != 1) { printf(\"%s\\n\", <\/FONT>PQgetvalue<\/FONT><\/A>(res, i, 0); i++; } <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\ubb3c\ub860 \uc774\ubc29\ubc95\ub300\uc2e0\uc5d0 <\/FONT>PQntuples<\/FONT><\/A>() \ud568\uc218\ub97c \uc774\uc6a9\ud574\uc11c \ub370\uc774\ud0c0\ub97c \uac00\uc838\uc62c\uc218\ub3c4 \uc788\uc744\uac83\uc774\ub2e4. <\/FONT><\/P>\n

 <\/P>\n

PQgetlength<\/FONT><\/A>() \ub97c \uc774\uc6a9\ud558\uba74 \uac00\uc838\uc628 \ub370\uc774\ud0c0\uc758 \uc2e4\uc81c \uae38\uc774\ub97c byte \ub2e8\uc704\ub85c \ub3cc\ub824\uc900\ub2e4. <\/FONT><\/P>\n\n\n\n
int <\/FONT>PQgetlength<\/FONT><\/A>(const PGresult *res, int tup_num, int field_num); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P><\/DIV>\n

\n
\n<\/FONT>\n

2.2.3.5\uc808. non select \uacb0\uacfc \uc815\ubcf4 \uac00\uc838\uc624\uae30<\/FONT><\/A><\/H4>\n

select \ub294 \uc9c1\uc811 \ub370\uc774\ud0c0\ub97c \uac00\uc838\uc624\ub294 \ucffc\ub9ac\uc9c0\ub9cc \uadf8\ub807\uc9c0 \uc54a\uc740 \ucffc\ub9ac\ub4e4\ub3c4 \uc788\ub2e4. insert, update, delete \ub4f1\uc774 \uc774\ub7ec\ud55c \ucffc\ub9ac\ub4e4\uc778\ub370, \ub370\uc774\ud0c0\ub97c \uac00\uc838\uc624\uc9c0 \uc54a\ub294 \ub300\uc2e0\uc5d0, insert \uc77c\uacbd\uc6b0\ub77c\uba74 insert \uac00 \uc81c\ub300\ub85c \ub418\uc5c8\ub294\uc9c0, update \ub77c\uba74 \uba87\uac1c\uc758 \ub370\uc774\ud0c0\uac00 update \ub418\uc5c8\ub294\uc9c0 \ub4f1\uc758 \uc815\ubcf4\uac00 \uc911\uc694\ud560\uac83\uc774\ub2e4. <\/FONT><\/P>\n

\ub9cc\uc57d insert, update, delete \ub4f1\uc758 \uba85\ub839\uc744 \uc0ac\uc6a9\ud588\uace0, \uba87\uac1c\uc758 \ub370\uc774\ud0c0\uac00 \uc774 \ucffc\ub9ac\uc5d0 \uc758\ud574\uc11c \uc801\uc6a9\uc774 \ub418\uc5c8\ub294\uc9c0 \uc54c\uace0 \uc2f6\ub2e4\uba74 <\/FONT>PQcmdTuples<\/FONT><\/A>() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. <\/FONT><\/P>\n\n\n\n
char * <\/FONT>PQcmdTuples<\/FONT><\/A>(const PGrsult *res); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

\ud568\uc218\uac00 \uc880 \uc774\uc0c1\ud574 \ubcf4\uc77c\uac83\uc774\ub2e4. \uc5b8\ub73b \uc0dd\uac01\ud574\ubcf4\uba74 \uc801\uc6a9\ub418\ub294 <\/FONT>\ub370\uc774\ud0c0\uc758<\/FONT><\/A>(tuple)\uc758 \uc218\ub97c \ub118\uaca8\uc8fc\ub294 \uac83\uc774\ubbc0\ub85c, \ub9ac\ud134\uac12\uc774 int \ud615\uc774\uc5ec\uc57c \ud560\uac83\uac19\uc740\ub370, char * \ud615\uc774\ub2e4. \uc65c char * \ub85c \ud588\ub294\uc9c0 \ud544\uc790\ub85c\uc368\ub3c4 \uc54c\uc218\ub294 \uc5c6\uc9c0\ub9cc, \uc5b4\uca0b\ub4e0 char * \ud615\uc73c\ub85c \ub118\uc5b4\uc628\ub2e4. \uadf8\ub798\uc11c \uc5b4\uca54\uc218 \uc5c6\uc774 <\/FONT>atoi<\/FONT><\/A>() \ub4f1\uc758 \ud568\uc218\uc0ac\uc6a9\ub3c4 \ud574\uc57c \ud560\uac83\uc774\ub2e4. <\/FONT><\/P>\n

 <\/P>\n

\ub610\ud55c <\/FONT>PQcmdStatus<\/FONT><\/A>() \ud568\uc218\ub97c \uc774\uc6a9\ud574\uc11c \ucffc\ub9ac \uc0c1\ud0dc\ub97c \uac80\uc0ac\ud560\uc218\ub3c4 \uc788\ub2e4. <\/FONT><\/P>\n\n\n\n
char * <\/FONT>PQcmdStatus<\/FONT><\/A>(const PGresult *res); <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P><\/DIV><\/DIV><\/DIV>\n

\n
\n<\/FONT>\n

2.3\uc808. \uc608\uc81c<\/FONT><\/A><\/H2>\n

\ub2e4\uc74c\uc740 \uac04\ub2e8\ud55c \uc608\uc81c\uc774\ub2e4. \ub9e4\uc6b0 \uac04\ub2e8\ud558\uc9c0\ub9cc \uc5b4\ub5bb\uac8c \uc5f0\uacb0\ud558\uace0 \ucffc\ub9ac\uacb0\uacfc\ub97c \uac00\uc838\uc624\uba70, \uc5d0\ub7ec\ub97c \ucc98\ub9ac\ud574\uc57c \ud558\ub294\uc9c0\uc5d0 \ub300\ud55c \uae30\ubcf8\uc801\uc778 \ub0b4\uc6a9\uc744 \ub2f4\uace0 \uc788\ub2e4. <\/FONT><\/P>\n

\uc608\uc81c : zipcode_psql.c<\/B> <\/FONT><\/P>\n\n\n\n
\/\/ libpq-fe.h \ub97c \ub9cc\ub4dc\uc2dc \ucd94\uac00\uc2dc\ucf1c\uc57c \ud55c\ub2e4.
#include <libpq-fe.h>
#include <nistd.h>
#include <stdlib.h>
#include <stdio.h>

int main<\/A>(int argc, char **argv)
{
    PGconn        *conn;
    PGresult      *res;

    int field_num;
    int row_num;
    int i;

    char query[128] = \"select * from zipcode\";
    char *pghost, *pgport, *pgoptions, *dbname,
         *pguser, *pgpass;

    pghost = \"localhost\";
    pgport = \"5432\";
    pgoptions = NULL;
    dbname = \"post\";

    pguser = \"yundream\";
    pgpass = \"1234\";

    \/\/ psql \ub370\uc774\ud0c0 \ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud55c\ub2e4.
    conn = PQsetdbLogin(pghost, pgport, pgoptions, NULL,
                        dbname, pguser, pgpass);

    \/\/ \ub9cc\uc57d \uc5f0\uacb0\uc5d0 \uc624\ub958\uac00 \ubc1c\uc0dd\ud588\ub2e4\uba74
    \/\/ \uc624\ub958\uba54\uc2dc\uc9c0\ub97c \ucd9c\ub825\ud55c\ub2e4\uc74c\uc5d0 \uc885\ub8cc\ud55c\ub2e4.
    if (PQstatus<\/A>(conn) == CONNECTION_BAD)
    {
        fprintf(stderr, \"%s\", PQerrorMessage<\/A>(conn));
        exit<\/A>(0);
    }

    \/\/ \uc544\uaddc\uba3c\ud2b8\uac00 \uc788\ub2e4\uba74 sido \uc640 dong \uc774\ub984\uc73c\ub85c like \uac80\uc0c9\uc744 \ud55c\ub2e4.
    \/\/ \uadf8\ub807\uc9c0 \uc54a\uc744\uacbd\uc6b0 \ubaa8\ub4e0 \uc6b0\ud3b8\ubc88\ud638 \ub9ac\uc2a4\ud2b8\ub97c \ucd9c\ub825\ud55c\ub2e4.
    if (argc == 2)
        sprintf(query, \"%s where sido like '%%%s%%' or dong like '%%%s%%'\", query, argv[1], argv[1]);

    \/\/ \ucffc\ub9ac\ub97c \ubc1c\uc0dd\uc2dc\ud0a8\ub2e4.
    res = PQexec<\/A>(conn, query);

    \/\/ \ucffc\ub9ac\uac00 \uc81c\ub300\ub85c \uc2e4\ud589\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4.
    \/\/ \uc81c\ub300\ub85c \uc2e4\ud589\ub418\uc9c0 \uc54a\uc558\ub2e4\uba74.
    \/\/ res \ub97c clear \uc2dc\ud0a4\uace0 \uc5f0\uacb0\uc744 \ub04a\uace0 \uc885\ub8cc\ud55c\ub2e4.
    if (PQresultStatus<\/A>(res) != PGRES_TUPLES_OK)
    {
        PQclear<\/A>(res);
        PQfinish<\/A>(conn);
        exit<\/A>(0);
    }

    \/\/ \uba87\uac1c\uc758 tuple \ub97c \uc5bb\uc5b4\uc654\ub294\uc9c0 \uac80\uc0ac\ud55c\ub2e4.
    row_num = PQntuples<\/A>(res);

    \/\/ \ub8e8\ud504\ub97c \ub3cc\uba74\uc11c \uac12\uc744 \ucd9c\ub825\ud55c\ub2e4.
    for (i = 0; i < row_num; i++)
    {
        printf(\"%s %s %-6s %-40s %s\\n\", PQgetvalue<\/A>(res, i, 1),
                                      PQgetvalue<\/A>(res, i, 2),
                                      PQgetvalue<\/A>(res, i, 3),
                                      PQgetvalue<\/A>(res, i, 4),
                                      PQgetvalue<\/A>(res, i, 5));
    }

    \/\/ \ucffc\ub9ac \uacb0\uacfc\ub97c \uc704\ud55c res \uac1d\uccb4\ub97c free \uc2dc\ucf1c\uc8fc\uace0
    \/\/ psql \uc11c\ubc84\uc640 \uc5f0\uacb0\uc744 \ub04a\uc740\ud6c4 \uc885\ub8cc\ud55c\ub2e4.
    PQclear<\/A>(res);
    PQfinish<\/A>(conn);

    return 1;
}
<\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

\ucef4\ud30c\uc77c \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4. <\/FONT><\/P>\n\n\n\n
[root@localhost test]# gcc -o zipcode_psql zipcode_psql.c \\ > -I\/usr\/local\/pgsql\/include -L\/usr\/local\/pgsql\/lib -lpq <\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

 <\/P>\n

\uc544\uaddc\uba3c\ud2b8\ub97c \uc8fc\uc9c0 \uc54a\uc744\uacbd\uc6b0 \uc804\uccb4 \uc6b0\ud3b8\ubc88\ud638 \ub9ac\uc2a4\ud2b8\ub97c \ucd9c\ub825\ud558\uba70, \uc544\uaddc\uba3c\ud2b8\uac00 \uc8fc\uc5b4\uc9c8 \uacbd\uc6b0 \ub3c4\uc2dc\uc640 \ub3d9 \uc774\ub984\uc73c\ub85c \uc77c\uce58\ud558\ub294 \uc6b0\ud3b8\ubc88\ud638 \ub9ac\uc2a4\ud2b8\ub97c \ucd9c\ub825\ud55c\ub2e4. <\/FONT><\/P>\n

\ucef4\ud30c\uc77c\uc774 \uc2e4\ud589\ub418\uc5c8\ub294\ub370\ub3c4 \ubd88\uad6c\ud558\uace0 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c\ub2e4\uba74, psql \uc11c\ubc84\uac00 \ub5a0\uc788\uc9c0 \uc54a\uac70\ub098 libpq \ub97c \ucc3e\uae30\uc704\ud55c \ud328\uc2a4 \uacbd\ub85c\uac00 \uc9c0\uc815\ub418\uc5b4 \uc788\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc77c\uac83\uc774\ub2e4. \/etc\/ld.so.conf \uc5d0 \ud328\uc2a4\uacbd\ub85c\ub97c \ucd94\uac00\uc2dc\ud0a4\uac70\ub098 \ud639\uc740 LD_LIBRARY_PATH \uc5d0 lipq \uacbd\ub85c\ub97c \ucd94\uac00\ud558\uae30 \ubc14\ub780\ub2e4. LD_LIBRARY \ud328\uc2a4 \ucd94\uac00 \ubc29\ubc95\uc740 <\/FONT>2.1.3\uc808<\/FONT><\/A> \ub97c \ucc38\uc870\ud558\uae30 \ubc14\ub780\ub2e4. <\/FONT><\/P><\/DIV><\/DIV>\n

\n
\n<\/FONT>\n

3\uc808. \uacb0\ub860<\/FONT><\/A><\/H1>\n

\uc774\uc0c1 \uac04\ub2e8\ud558\uac8c postgresql \uc758 \uc124\uce58\ubc29\ubc95\uacfc libpq \ub97c \uc774\uc6a9\ud55c \ud504\ub85c\uadf8\ub798\ubc0d \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \ub2e4\ub8e8\uc5b4 \ubcf4\uc558\ub2e4. \uc5ec\uae30\uc5d0\uc11c \uc18c\uac1c\ud55c \ud568\uc218\ub4e4\uacfc \uc608\uc81c\ub294 \ucd5c\uc18c\ud55c\uc758 \uae30\ub2a5\uc744 \ubcf4\uc5ec\uc8fc\uae30 \uc704\ud55c \uac83\ub4e4\uc774\ub2e4. <\/FONT><\/P>\n

\ube44\ub85d \uc660\ub9cc\ud55c \ud504\ub85c\uadf8\ub7a8\uc774\ub77c\uba74 \uc704\uc758 \uac83\ub4e4\uc744 \ud1b5\ud574\uc11c\ub3c4 \uc81c\uc791\uc774 \uac00\ub2a5\ud558\uc9c0\ub9cc \uc880\ub354 \ubcf5\uc7a1\ud55c \uc694\uad6c\uc0c1\uc774 \ud544\uc694\ud55c \ud504\ub85c\uadf8\ub7a8\uc774\ub77c\uba74 pgsql \uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ubb38\uc11c\ub97c \uc77d\uc5b4\ubd10\uc57c \ud560\uac83\uc774\ub2e4. <\/FONT><\/P>\n

\ub098\uc911\uc5d0 \uae30\ud68c\uac00 \ub418\ub294\ub300\ub85c libpq \uc5d0 \ub300\ud55c \uc880\ub354 \uc138\ubc00\ud55c \ub0b4\uc6a9\uc744 \ub2e4\ub904\ubcf4\ub3c4\ub85d \ud558\uaca0\ub2e4.  <\/FONT><\/P><\/DIV><\/DIV>\n","protected":false},"excerpt":{"rendered":"

Postgresql \ud504\ub85c\uadf8\ub798\ubc0d \uc724 \uc0c1\ubc30 dreamyun@yahoo.co.kr  \ucc28\ub840 1\uc808. Postgresql \uc5d0 \ub300\ud55c \uc18c\uac1c 2\uc808. Postgresql \ud504\ub85c\uadf8\ub798\ubc0d 2.1\uc808. Postgresql \uc124\uce58\ud558\uae30 2.1.1\uc808. \ub2e4\uc6b4\ubc1b\uae30 2.1.2\uc808. \ucef4\ud30c\uc77c \ud558\uae30 2.1.3\uc808. \ud658\uacbd\uc124\uc815 2.1.4\uc808. \uc11c\ubc84\uc2e4\ud589 2.2\uc808. \ud504\ub85c\uadf8\ub7a8 \uc81c\uc791 2.2.1\uc808. \ud14c\uc2a4\ud2b8\uc6a9 DB \ub9cc\ub4e4\uae30 2.2.2\uc808. \uc5b4\ub5a4 \ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4\uac83\uc778\uac00 2.2.3\uc808. libpq (C library) 2.2.3.1\uc808. DB \uc5f0\uacb0\/\ud574\uc81c\uad00\ub828 2.2.3.2\uc808. \ucffc\ub9ac\uc2e4\ud589 \uad00\ub828 2.2.3.3\uc808. select \ucffc\ub9ac \uacb0\uacfc \uc815\ubcf4\ub97c \uac00\uc838\uc624\uae30 2.2.3.4\uc808. select […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[19],"tags":[],"class_list":["post-62","post","type-post","status-publish","format-standard","hentry","category-development_lib"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/62","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=62"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}