noribsd Sun Feb 25 09:48:21 2001 EDT
Modified files:
/phpdoc/kr/functions pgsql.xml
Log:
translated a little bit of sentences
Index: phpdoc/kr/functions/pgsql.xml
diff -u phpdoc/kr/functions/pgsql.xml:1.2 phpdoc/kr/functions/pgsql.xml:1.3
--- phpdoc/kr/functions/pgsql.xml:1.2 Fri Jan 12 06:16:40 2001
+++ phpdoc/kr/functions/pgsql.xml Sun Feb 25 09:48:21 2001
@@ -1,91 +1,81 @@
- <reference id="ref.pgsql">
- <title>PostgreSQL functions</title>
- <titleabbrev>PostgreSQL</titleabbrev>
-
- <partintro>
- <para>
- Postgres, developed originally in the UC Berkeley Computer Science
- Department, pioneered many of the object-relational concepts now
- becoming available in some commercial databases. It provides
- SQL92/SQL3 language support, transaction integrity, and type
- extensibility. PostgreSQL is an open source descendant of this
- original Berkeley code.
- </para>
- <para>
- PostgreSQL is available without cost. The current version is
- available at <ulink url="&url.pgsql;">www.PostgreSQL.org</ulink>.
+<reference id="ref.pgsql">
+ <title>PostgreSQL functions</title>
+ <titleabbrev>PostgreSQL</titleabbrev>
+ <partintro>
+ <para>
+ Postgres는 본래 버클리대학의 컴퓨터 사이언스 학부에서
+학술적인 목적으로
+ 개발되었던 데이터베이스로, 현재 몇몇 상용
+데이터베이스들이 채용하고 있는
+ 객체관계 개념을 실험적으로 적용시켜왔다. Postgres는
+SQL92/SQL3언어,
+ 트랜잭션간의 무결성 및 기타 확장가능한 형식을
+지원한다. PostgreSQL은
+ 이같은 버클리대학의 코드를 근간으로 개발되고 있는
+오픈소스의 성과물이다.
</para>
- <para>
- Since version 6.3 (03/02/1998) PostgreSQL uses unix domain sockets.
- A table is shown below describing these new connection possibilities.
- This socket will be found in <filename>/tmp/.s.PGSQL.5432</filename>.
- This option can be enabled with the '-i' flag to <command>postmaster
- </command> and it's meaning is: "listen on TCP/IP sockets as well as
- Unix domain sockets".
+ <para>
+ PostgreSQL의 배포는 무료이며 최신버전은
+ <ulink url="&url.pgsql;">www.PostgreSQL.org</ulink> 에서 구할 수 있다.
+ </para>
+ <para>
+ PostgreSQL은 버전 6.3(1998년 3월 2일 발표)부터 유닉스 도메인
+소켓
+ (unix domain sockets)을 사용한다. 아래의 테이블은 유닉스
+도메인 소켓을
+ 사용한 새로운 데이타베이스 접속예를 나타내고 있다.
+소켓의 경로는
+ <filename>/tmp/.s.PGSQL.5432</filename> 이다. 이 옵션은
+ <command>postmaster</command> 에 -i 플래그를 넣어줌으로써
+가능하며
+ 그 의미는 "유닉스 도메인 소켓의 응답과 함께 TCP/IP 소켓의
+응답도 동시에
+ 기다린다"는 뜻이다.
<table>
- <title>Postmaster and PHP</title>
- <tgroup cols="3">
- <thead>
- <row>
- <entry>Postmaster</entry>
- <entry>PHP</entry>
- <entry>Status</entry>
- </row>
- </thead>
- <tbody>
- <row>
- <entry>postmaster &</entry>
- <entry>pg_connect("dbname=MyDbName");</entry>
- <entry>OK</entry>
- </row>
- <row>
- <entry>postmaster -i &</entry>
- <entry>pg_connect("dbname=MyDbName");</entry>
- <entry>OK</entry>
- </row>
- <row>
- <entry>postmaster &</entry>
- <entry>pg_connect("host=localhost dbname=MyDbName");</entry>
- <entry>
+ <title>Postmaster and PHP</title>
+ <tgroup cols="3">
+ <thead>
+ <row>
+ <entry>Postmaster</entry>
+ <entry>PHP</entry>
+ <entry>Status</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry>postmaster &</entry>
+
+<entry>pg_connect("dbname=MyDbName");</entry>
+ <entry>OK</entry>
+ </row>
+ <row>
+ <entry>postmaster -i
+&</entry>
+
+<entry>pg_connect("dbname=MyDbName");</entry>
+ <entry>OK</entry>
+ </row>
+ <row>
+ <entry>postmaster &</entry>
+
+<entry>pg_connect("host=localhost dbname=MyDbName");</entry>
+ <entry>
Unable to connect to PostgreSQL server: connectDB() failed:
Is the postmaster running and accepting TCP/IP (with -i)
connection at 'localhost' on port '5432'? in
/path/to/file.php3 on line 20.
</entry>
- </row>
- <row>
- <entry>postmaster -i &</entry>
- <entry>pg_connect("host=localhost dbname=MyDbName");</entry>
- <entry>OK</entry>
- </row>
- </tbody>
- </tgroup>
- </table>
- </para>
- <para>
- One can establish a connection with the following value pairs
- set in the command string:
- <command>$conn = pg_Connect("host=myHost port=myPort tty=myTTY
- options=myOptions user=myUser password=myPassword dbname=myDB");
- </command>
- </para>
- <para>
- The previous syntax of:
- <command>$conn = pg_connect ("host", "port", "options", "tty",
- "dbname")
- </command>
- has been deprecated.
- </para>
- <para>
- To use the large object (lo) interface, it is necessary to enclose
- it within a transaction block. A transaction block starts with a
- <command>begin</command> and if the transaction was valid ends
- with <command>commit</command> or <command>end</command>. If the
- transaction fails the transaction should be closed with
- <command>rollback</command> or <command>abort</command>.
- <example>
- <title>Using Large Objects</title>
- <programlisting role="php">
+ </row>
+ <row>
+ <entry>postmaster -i
+&</entry>
+
+<entry>pg_connect("host=localhost dbname=MyDbName");</entry>
+ <entry>OK</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </table>
+ </para>
+ <para>
+ PHP로 PostgreSQL에 접속하는 코드의 예제는 다음과 같다:
+ <command>$conn = pg_Connect("host=myHost port=myPort tty=myTTY
+options=myOptions user=myUser password=myPassword dbname=myDB");</command>
+ </para>
+ <para>
+ 예전에 사용하던 <command>$conn = pg_connect ("host", "port", "options",
+"tty", "dbname")</command> 은 추천하지 않는다.
+ </para>
+ <para>
+ PHP에서 PostgreSQL의 Large Object 기능을 사용하려면 그것을
+트랜잭션 블럭안에 포함시켜야 한다.
+ 트랜잭션 블럭은 <command>begin</command> 으로 시작해서
+<command>commit</command>
+ 혹은 <command>end</command>로 끝난다. 만약 트랜잭션이
+실패하였다면 그 실패한 트랜잭션은
+ 반드시 <command>rollback</command> 혹은 <command>abort</command> 로
+끝나야 한다.
+ <example>
+ <title>Using Large Objects</title>
+ <programlisting role="php">
<?php
$database = pg_Connect ("dbname=jacarta");
pg_exec ($database, "begin");
@@ -98,283 +88,290 @@
pg_exec ($database, "commit");
?>
</programlisting>
- </example>
+ </example>
+ </para>
+ </partintro>
+ <refentry id="function.pg-close">
+ <refnamediv>
+ <refname>pg_close</refname>
+ <refpurpose>PostgreSQL과의 접속을 끊는다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>bool <function>pg_close</function>
+ </funcdef>
+ <paramdef>int <parameter>connection</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ 올바른 접속지시자(a valid connection index)가 아니라면
+거짓(false)를
+ 돌려주고, 반대의 경우 참(true)을 돌려준다. 인수로 주어진
+접속지시자에
+ 해당하는 PostgreSQL로의 접속을 끊는다.
+ </para>
+ <note>
+ <para>
+ 영구적이지 않은 접속은 PHP 스크립트의 종료시 자동으로
+닫히므로
+ 대부분의 경우 이 함수를 이용하여 접속을 끊지 않아도 된다.
</para>
- </partintro>
-
- <refentry id="function.pg-close">
- <refnamediv>
- <refname>pg_close</refname>
- <refpurpose>Close a PostgreSQL connection</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>bool <function>pg_close</function></funcdef>
- <paramdef>int <parameter>connection</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- Returns false if connection is not a valid connection index, true
- otherwise. Closes down the connection to a PostgreSQL database
- associated with the given connection index.
- </para>
- <note><para>
- This isn't usually necessary, as non-persistent open
- links are automatically closed at the end of the script's
- execution.
- </para></note>
- <para>
- <function>pg_close</function> will not close persistent links
- generated by <function>pg_pconnect</function>.
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-cmdtuples">
- <refnamediv>
- <refname>pg_cmdtuples</refname>
- <refpurpose>Returns number of affected tuples</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_cmdtuples</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_cmdtuples</function> returns the number of tuples
- (instances) affected by INSERT, UPDATE, and DELETE queries. If no
- tuple is affected the function will return 0.
+ </note>
+ <para>
+ <function>pg_close</function> 함수는
+ <function>pg_pconnect</function>를 이용한 접속을 끊지 못한다.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-cmdtuples">
+ <refnamediv>
+ <refname>pg_cmdtuples</refname>
+ <refpurpose>데이터베이스 명령어에 영향을 받은
+튜플의 갯수를 돌려준다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_cmdtuples</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_cmdtuples</function> 는 INSERT, UPDATE,
+DELETE 쿼리에 의해 영향을
+ 받은 튜플(tuples 혹은 instances)의 갯수를
+돌려준다. 만약 영향을 받은 튜플이 없다면
+ 0을 돌려준다.
<example>
- <title><function>Pg_cmdtuples</function></title>
- <programlisting role="php">
+ <title>
+ <function>Pg_cmdtuples</function>
+ </title>
+ <programlisting role="php">
<?php
$result = pg_exec ($conn, "INSERT INTO publisher VALUES ('Author')");
$cmdtuples = pg_cmdtuples ($result);
-echo $cmdtuples . " <- cmdtuples affected.";
+echo $cmdtuples . " <- 영향을 받은 튜플입니다.";
?>
</programlisting>
- </example>
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-connect">
- <refnamediv>
- <refname>pg_connect</refname>
- <refpurpose>Open a PostgreSQL connection</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_connect</function></funcdef>
- <paramdef>string <parameter>conn_string</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- Returns a connection index on success, or false if the connection
- could not be made. Opens a connection to a PostgreSQL database.
- The arguments should be within a quoted string.
- <example>
- <title>Using pg_connect arguments</title>
- <programlisting role="php">
+ </example>
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-connect">
+ <refnamediv>
+ <refname>pg_connect</refname>
+ <refpurpose>PostgreSQL에 접속한다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_connect</function>
+ </funcdef>
+ <paramdef>string
+<parameter>conn_string</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ 접속에 성공하면 접속지시자(a connection index)를
+돌려주고,
+ 실패하면 거짓(false)을 돌려준다. 이 함수의
+목적은 PostgreSQL에
+ 접속하는 것이다. 인수들은 인용부호안에
+표기해야 한다.
+ <example>
+ <title>Using pg_connect arguments</title>
+ <programlisting role="php">
<?php
$dbconn = pg_Connect ("dbname=mary");
-//connect to a database named "mary"
+// "mary"라는 이름의 데이터베이스에 접속
$dbconn2 = pg_Connect ("host=localhost port=5432 dbname=mary");
-//connect to a database named "mary" on "localhost" at port "5432"
+// "localhost"의 "5432"포트를 통해 "mary"라는 이름의 데이터베이스에
+접속
$dbconn3 = pg_Connect ("user=lamb password=baaaa dbname=mary ");
-//connect to a database named "mary" with a username and password
+// 유저명과 패스워드가 지정된 "mary"라는 이름의
+데이터베이스에 접속
?>
</programlisting>
- </example>
- The arguments available include <parameter>dbname</parameter>
- <parameter>port</parameter>, <parameter>host</parameter>,
+ </example>
+ 이 함수와 함께 사용 가능한 인수는 <parameter>dbname</parameter>
+ <parameter>port</parameter>,
+<parameter>host</parameter>,
<parameter>tty</parameter>, <parameter>options</parameter>,
- <parameter>user</parameter>, and <parameter>password</parameter>
- </para>
- <para>
- This function returns a connection index that is needed by other
- PostgreSQL functions. You can have multiple connections open at
- once.
- </para>
- <para>
- The previous syntax of:
+ <parameter>user</parameter>, 그리고 <parameter>password</parameter>이다.
+ </para>
+ <para>
+ 이 함수는 PHP의 다른 PostgreSQL 함수에서 필요로 하는
+접속지시자를
+ 돌려준다. 필요하다면 한번에 여러개의 접속을 만들 수
+있다.
+ </para>
+ <para>
+ 예전에 사용하던 접속구문
<command>$conn = pg_connect ("host", "port", "options", "tty",
"dbname")
</command>
- has been deprecated.
- </para>
- <para>
- See also <function>pg_pconnect</function>.
+ 은 추천하지 않는다.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-dbname">
- <refnamediv>
- <refname>pg_dbname</refname>
- <refpurpose>Get the database name</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>string <function>pg_dbname</function></funcdef>
- <paramdef>int <parameter>connection</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- Returns the name of the database that the given PostgreSQL
- connection index is connected to, or false if connection is not a
- valid connection index.
+ <para>
+ <function>pg_pconnect</function>도 참고하라.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-end-copy">
- <refnamediv>
- <refname>pg_end_copy</refname>
- <refpurpose>Sync with PostgreSQL backend</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>bool <function>pg_end_copy</function></funcdef>
- <paramdef>resource
- <parameter><optional>connection</optional></parameter>
- </paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>pg_end_copy</function> syncs PostgreSQL frontend with
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-dbname">
+ <refnamediv>
+ <refname>pg_dbname</refname>
+ <refpurpose>데이터베이스의 이름을
+돌려준다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>string <function>pg_dbname</function>
+ </funcdef>
+ <paramdef>int <parameter>connection</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ 인수로 주어진 접속지시자 (connection index)에
+해당하는 데이터베이스
+ 이름을 돌려준다. 올바른 접속지시자가 아니면
+거짓(false)을 돌려준다.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-end-copy">
+ <refnamediv>
+ <refname>pg_end_copy</refname>
+ <refpurpose>PostgreSQL 백엔드에
+동기화한다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>bool <function>pg_end_copy</function>
+ </funcdef>
+ <paramdef>resource
+ <parameter>
+ <optional>connection</optional>
+ </parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>pg_end_copy</function> syncs PostgreSQL
+frontend with
the backend after doing a copy operation. It must be issued or
the backend may get "out of sync" with the frontend. Returns
TRUE if successfull, FALSE otherwise.
</para>
- <para>
+ <para>
For further details and an example, see also
<function>pg_put_line</function>.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-errormessage">
- <refnamediv>
- <refname>pg_errormessage</refname>
- <refpurpose>Get the error message string</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>string <function>pg_errormessage</function></funcdef>
- <paramdef>int <parameter>connection</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- Returns a string containing the error message, false on failure.
- Details about the error probably cannot be retrieved using the
- <function>pg_errormessage</function> function if an error occured
- on the last database action for which a valid connection exists,
- this function will return a string containing the error message
- generated by the backend server.
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-exec">
- <refnamediv>
- <refname>pg_exec</refname>
- <refpurpose>Execute a query</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_exec</function></funcdef>
- <paramdef>int <parameter>connection</parameter></paramdef>
- <paramdef>string <parameter>query</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- Returns a result index if query could be executed, false on
- failure or if connection is not a valid connection index. Details
- about the error can be retrieved using the
- <function>pg_ErrorMessage</function> function if connection is
- valid. Sends an SQL statement to the PostgreSQL database
- specified by the connection index. The connection must be a valid
- index that was returned by <function>pg_Connect</function>. The
- return value of this function is an index to be used to access
- the results from other PostgreSQL functions.
- <note>
- <simpara>
- PHP/FI returned 1 if the query was not expected to return data
- (inserts or updates, for example) and greater than 1 even on
- selects that did not return anything. No such assumption can be
- made in PHP.
- </simpara>
- </note>
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-fetch-array">
- <refnamediv>
- <refname>pg_fetch_array</refname>
- <refpurpose>Fetch a row as an array</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>array <function>pg_fetch_array</function></funcdef>
- <paramdef>int <parameter>result</parameter></paramdef>
- <paramdef>int <parameter>row</parameter></paramdef>
- <paramdef>int
- <parameter><optional>result_type</optional></parameter>
- </paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- Returns: An array that corresponds to the fetched row, or false
- if there are no more rows.
- </para>
- <para>
- <function>Pg_fetch_array</function> is an extended version of
- <function>pg_fetch_row</function>. In addition to storing the
- data in the numeric indices of the result array, it also stores
- the data in associative indices, using the field names as keys.
- </para>
- <para>
- The third optional argument <parameter>result_type</parameter> in
- <function>pg_fetch_array</function> is a constant and can take the
- following values: PGSQL_ASSOC, PGSQL_NUM, and PGSQL_BOTH.
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-errormessage">
+ <refnamediv>
+ <refname>pg_errormessage</refname>
+ <refpurpose>데이터베이스의 에러메시지를
+가져온다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>string
+<function>pg_errormessage</function>
+ </funcdef>
+ <paramdef>int <parameter>connection</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ 실행에 성공한 경우 데이터베이스에서 생성된
+에러메시지 문자열을
+ 돌려주며, 실패한 경우 거짓(false)을 돌려준다.
+<function>pg_errormessage</function> 함수는
+ PHP가 직접 생성해낸 에러메시지처럼 (그
+에러가 발생한 라인번호같은) 자세한 정보는 출력하지
+ 않지만, (인수로 주어진 접속지시자에
+해당하는) 백엔드서버에서 생성된 가장 마지막 에러메시지
+ 문자열을 돌려준다.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-exec">
+ <refnamediv>
+ <refname>pg_exec</refname>
+ <refpurpose>쿼리를 실행한다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_exec</function>
+ </funcdef>
+ <paramdef>int <parameter>connection</parameter>
+ </paramdef>
+ <paramdef>string <parameter>query</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ 쿼리가 성공적으로 실행되었을 경우 결과지시자(a result
+index)를 돌려준다.
+ 쿼리의 실행이 실패하였거나 올바르지 않은 접속지시자(not
+a valid connection index)가
+ 인수로 주어졌을 경우 거짓(false)을 돌려준다.
+에러메시지는 <function>pg_errormessage</function> 함수에
+ 올바른 접속지시자를 인수로 넣어 가져올 수 있다.
+<function>pg_exec</function> 함수는 인수로 주어진
+ 접속지시자에 해당하는 접속을 통해 PostgreSQL에 실행시킬
+SQL구문을 전달한다. 이때 쓰이는 접속지시자는
+ <function>pg_connect</function> 함수를 통해 돌려보내진 올바른
+접속지시자여야 한다. 참고로
+ <function>pg_connect</function> 함수를 통해 생성된 지시자는
+PHP에서 제공하는 다른 PostgreSQL
+ 관련 함수들의 동작을 위해 사용된다.
+ <note>
+ <simpara>
+ PHP/FI에서는 데이터베이스에 저장된 자료를 가져오지
+않는 쿼리(예: insert나 update등)의 결과값으로
+ 1을, 만족하는 조건이 없는 select 쿼리의 경우 1보다
+큰 수를 돌려주었다. 이것은 현재의 PHP에서는
+ 찾아볼 수 없는 기능이다.
+ </simpara>
+ </note>
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-fetch-array">
+ <refnamediv>
+ <refname>pg_fetch_array</refname>
+ <refpurpose>데이터베이스의 행을 배열로
+가져온다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>array
+<function>pg_fetch_array</function>
+ </funcdef>
+ <paramdef>int <parameter>result</parameter>
+ </paramdef>
+ <paramdef>int <parameter>row</parameter>
+ </paramdef>
+ <paramdef>int
+ <parameter>
+
+<optional>result_type</optional>
+ </parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ 이 함수는 데이터베이스에서 가져온 행을
+배열로 돌려주며,
+ 만약 더이상 가져올 행이 없는 경우
+거짓(false)을 돌려준다.
+ </para>
+ <para>
+ <function>pg_fetch_array</function> 함수는
+<function>pg_fetch_row</function> 함수의
+ 확장된 버전으로, 숫자를 인덱스로 하는
+배열은 물론이고 각 필드이름을 인덱스로 하는
+ 배열 두가지 형태를 고를 수 있다.
+ </para>
+ <para>
+ 세번째로 정의된 <parameter>result_type</parameter>
+인수는 선택적으로 주어질 수 있는
+ 상수의 형태로 다음과 같은 값을 취할 수 있다:
+PGSQL_ASSOC, PGSQL_NUM, 그리고 PGSQL_BOTH.
<note>
- <para>
- <parameter>Result_type</parameter> was added in PHP 4.0.
+ <para>
+ <parameter>Result_type</parameter>
+인수는 PHP 4.0 버전부터 추가되었다.
</para>
- </note>
- </para>
- <para>
- An important thing to note is that using
- <function>pg_fetch_array</function> is NOT significantly
- slower than using <function>pg_fetch_row</function>, while it
- provides a significant added value.
- </para>
- <para>
- For further details, see also
- <function>pg_fetch_row</function>
- </para>
- <example>
- <title>PostgreSQL fetch array</title>
- <programlisting role="php">
+ </note>
+ </para>
+ <para>
+ 한가지 중요한 사실은
+<function>pg_fetch_array</function> 함수에 <function>pg_fetch_row</function>
+ 함수보다 요긴하게 사용될 수 있는
+기능(siginificant added value)이 추가되었지만 실행속도는 그다지
+ 느리지 않다는 것이다.
+ </para>
+ <para>
+ <function>pg_fetch_row</function>도 참고하라.
+ </para>
+ <example>
+ <title>PostgreSQL fetch array</title>
+ <programlisting role="php">
<?php
$conn = pg_pconnect ("dbname=publisher");
if (!$conn) {
@@ -395,60 +392,60 @@
echo $arr["author"] . " <- array\n";
?>
</programlisting>
- </example>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-fetch-object">
- <refnamediv>
- <refname>pg_fetch_object</refname>
- <refpurpose>Fetch a row as an object</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>object <function>pg_fetch_object</function></funcdef>
- <paramdef>int <parameter>result</parameter></paramdef>
- <paramdef>int <parameter>row</parameter></paramdef>
- <paramdef>int
- <parameter><optional>result_type</optional></parameter>
- </paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- Returns: An object with properties that correspond to the fetched
- row, or false if there are no more rows.
- </para>
- <para>
- <function>Pg_fetch_object</function> is similar to
- <function>pg_fetch_array</function>, with one difference - an
- object is returned, instead of an array. Indirectly, that means
- that you can only access the data by the field names, and not by
- their offsets (numbers are illegal property names).
- </para>
- <para>
- The third optional argument <parameter>result_type</parameter> in
- <function>pg_fetch_object</function> is a constant and can take the
- following values: PGSQL_ASSOC, PGSQL_NUM, and PGSQL_BOTH.
+ </example>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-fetch-object">
+ <refnamediv>
+ <refname>pg_fetch_object</refname>
+ <refpurpose>데이터베이스의 행을 오브젝트로
+가져온다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>object
+<function>pg_fetch_object</function>
+ </funcdef>
+ <paramdef>int <parameter>result</parameter>
+ </paramdef>
+ <paramdef>int <parameter>row</parameter>
+ </paramdef>
+ <paramdef>int
+ <parameter>
+
+<optional>result_type</optional>
+ </parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ 데이터베이스의 행을 그 행이 가진 프로퍼티와
+함께 오브젝트의 형태로 돌려주며,
+ 더이상 가져올 행이 없을 경우 거짓(false)을
+돌려준다.
+ </para>
+ <para>
+ <function>pg_fetch_object</function> 함수는
+<function>pg_fetch_array</function> 함수와
+ 거의 비슷하지만, 중요한 한가지가 다르다 --
+배열을 돌려주는 대신 오브젝트를 돌려준다.
+ 간접적인 의미로, 여러분은 그 데이터를
+오직 그 필드의 이름으로만 접근(access)할 수
+ 있으며 오프셋(offsets)으로는 접근이
+불가능하다. (숫자는 올바른 프로퍼티 이름이 아니다)
+ </para>
+ <para>
+ 세번째로 정의된 <parameter>result_type</parameter>
+인수는 선택적으로 주어질 수 있는
+ 상수의 형태로 다음과 같은 값을 취할 수 있다:
+PGSQL_ASSOC, PGSQL_NUM, 그리고 PGSQL_BOTH.
<note>
- <para>
- <parameter>Result_type</parameter> was added in PHP 4.0.
+ <para>
+ <parameter>Result_type</parameter> 은
+PHP 4.0 버전부터 추가되었다.
</para>
- </note>
- </para>
- <para>
- Speed-wise, the function is identical to
- <function>pg_fetch_array</function>, and almost as quick as
- <function>pg_fetch_row</function> (the difference is
- insignificant).
- </para>
- <para>
- See also: <function>pg_fetch_array</function> and
- <function>pg_fetch_row</function>.
+ </note>
+ </para>
+ <para>
+ 함수 실행 속도는 <function>pg_fetch_array</function>
+함수와 마찬가지로,
+ <function>pg_fetch_row</function> 함수만큼 충분히
+빠르다. (그 차이는 미미하다)
+ </para>
+ <para>
+ <function>pg_fetch_array</function> 와
+ <function>pg_fetch_row</function> 도 참고하라.
<example>
- <title>Postgres fetch object</title>
- <programlisting role="php">
+ <title>Postgres fetch object</title>
+ <programlisting role="php">
<?php
$database = "verlag";
$db_conn = pg_connect ("host=localhost port=5432 dbname=$database");
@@ -458,7 +455,7 @@
endif;
$qu = pg_exec ($db_conn, "SELECT * FROM verlag ORDER BY autor");
-$row = 0; // postgres needs a row counter other dbs might not
+$row = 0; // postgres는 다른 데이터베이스들이 필요로 하지 않는
+행카운터(row counter)를 필요로 한다
while ($data = pg_fetch_object ($qu, $row)):
echo $data->autor." (";
@@ -472,7 +469,7 @@
$fields[] = Array ("jahr", " Year");
$fields[] = Array ("titel", " Title");
-$row= 0; // postgres needs a row counter other dbs might not
+$row= 0; // postgres는 다른 데이터베이스들이 필요로 하지 않는
+행카운터를 필요로 한다
while ($data = pg_fetch_object ($qu, $row)):
echo "----------\n";
reset ($fields);
@@ -487,42 +484,42 @@
pg_close ($db_conn);
?>
</programlisting>
- </example>
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-fetch-row">
- <refnamediv>
- <refname>pg_fetch_row</refname>
- <refpurpose>Get a row as an enumerated array</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>array <function>pg_fetch_row</function></funcdef>
- <paramdef>int <parameter>result</parameter></paramdef>
- <paramdef>int <parameter>row</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- Returns: An array that corresponds to the fetched row, or false
- if there are no more rows.
- </para>
- <para>
- <function>Pg_fetch_row</function> fetches one row of data from
- the result associated with the specified result identifier. The
- row is returned as an array. Each result column is stored in an
- array offset, starting at offset 0.
- </para>
- <para>
- See also: <function>pg_fetch_array</function>,
+ </example>
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-fetch-row">
+ <refnamediv>
+ <refname>pg_fetch_row</refname>
+ <refpurpose>데이터베이스의 행을 숫자를
+인덱스로 하는 배열로 가져온다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>array
+<function>pg_fetch_row</function>
+ </funcdef>
+ <paramdef>int <parameter>result</parameter>
+ </paramdef>
+ <paramdef>int <parameter>row</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ 데이터베이스로부터 가져온 행을 배열형태로
+돌려주며, 더이상 가져올 행이 없을 경우 거짓(false)을 돌려준다.
+ </para>
+ <para>
+ <function>pg_fetch_row</function> 함수는 인수로
+주어진 결과지시자(result identifier)가
+ 가리키는 쿼리의 결과로부터 데이터베이스의
+한 행을 배열 형태로 가져온다. 각 결과컬럼
+ 은 0으로 시작되는 배열오프셋(array offset)에
+저장된다.
+ </para>
+ <para>
+ <function>pg_fetch_array</function>,
<function>pg_fetch_object</function>,
- <function>pg_result</function>.
+ <function>pg_result</function> 도 참고하라.
<example>
- <title>Postgres fetch row</title>
- <programlisting role="php">
+ <title>Postgres fetch row</title>
+ <programlisting role="php">
<?php
$conn = pg_pconnect ("dbname=publisher");
if (!$conn) {
@@ -551,194 +548,205 @@
?>
</programlisting>
- </example>
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-fieldisnull">
- <refnamediv>
- <refname>pg_fieldisnull</refname>
- <refpurpose>Test if a field is NULL</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_fieldisnull</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- <paramdef>int <parameter>row</parameter></paramdef>
- <paramdef>mixed <parameter>field</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- Test if a field is NULL or not. Returns 0 if the field in the
- given row is not NULL. Returns 1 if the field in the given row is
- NULL. Field can be specified as number or fieldname. Row
- numbering starts at 0.
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-fieldname">
- <refnamediv>
- <refname>pg_fieldname</refname>
- <refpurpose>Returns the name of a field</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>string <function>pg_fieldname</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- <paramdef>int <parameter>field_number</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_fieldname</function> will return the name of the
- field occupying the given column number in the given PostgreSQL
- result identifier. Field numbering starts from 0.
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-fieldnum">
- <refnamediv>
- <refname>pg_fieldnum</refname>
- <refpurpose>Returns the field number of the named field</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_fieldnum</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- <paramdef>string <parameter>field_name</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_fieldnum</function> will return the number of the
+ </example>
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-fieldisnull">
+ <refnamediv>
+ <refname>pg_fieldisnull</refname>
+ <refpurpose>필드가 NULL인지 검사한다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int
+<function>pg_fieldisnull</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ <paramdef>int <parameter>row</parameter>
+ </paramdef>
+ <paramdef>mixed <parameter>field</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ 필드가 NULL인지 아닌지 검사한다. 인수로
+주어진 행에 해당하는 필드가 NULL이 아니면
+ 0을 돌려주고 NULL인 경우 1을 돌려준다. 필드는
+숫자와 필드이름 두가지로 정의될 수 있다.
+ 행의 번호는 0부터 매겨진다.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-fieldname">
+ <refnamediv>
+ <refname>pg_fieldname</refname>
+ <refpurpose>필드의 이름을 돌려준다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>string
+<function>pg_fieldname</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ <paramdef>int
+<parameter>field_number</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_fieldname</function> 함수는 인수로
+주어진 결과지시자가 가리키는
+ 컬럼번호에 해당하는 이름을 돌려준다.
+필드번호는 0부터 매겨진다.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-fieldnum">
+ <refnamediv>
+ <refname>pg_fieldnum</refname>
+ <refpurpose>Returns the field number of the named
+field</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_fieldnum</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ <paramdef>string
+<parameter>field_name</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_fieldnum</function> will return the
+number of the
column slot that corresponds to the named field in the given
PosgreSQL result identifier. Field numbering starts at 0. This
function will return -1 on error.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-fieldprtlen">
- <refnamediv>
- <refname>pg_fieldprtlen</refname>
- <refpurpose>Returns the printed length</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_fieldprtlen</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- <paramdef>int <parameter>row_number</parameter></paramdef>
- <paramdef>string <parameter>field_name</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_fieldprtlen</function> will return the actual
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-fieldprtlen">
+ <refnamediv>
+ <refname>pg_fieldprtlen</refname>
+ <refpurpose>Returns the printed length</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int
+<function>pg_fieldprtlen</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ <paramdef>int <parameter>row_number</parameter>
+ </paramdef>
+ <paramdef>string
+<parameter>field_name</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_fieldprtlen</function> will return the
+actual
printed length (number of characters) of a specific value in a
PostgreSQL result. Row numbering starts at 0. This function
will return -1 on an error.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-fieldsize">
- <refnamediv>
- <refname>pg_fieldsize</refname>
- <refpurpose>
- Returns the internal storage size of the named field
- </refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_fieldsize</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- <paramdef>int <parameter>field_number</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_fieldsize</function> will return the internal
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-fieldsize">
+ <refnamediv>
+ <refname>pg_fieldsize</refname>
+ <refpurpose>
+ 주어진 필드의 내부저장 공간의 크기를 돌려준다.
+</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_fieldsize</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ <paramdef>int
+<parameter>field_number</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_fieldsize</function> will return the
+internal
storage size (in bytes) of the field number in the given
PostgreSQL result. Field numbering starts at 0. A field size of
-1 indicates a variable length field. This function will return
false on error.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-fieldtype">
- <refnamediv>
- <refname>pg_fieldtype</refname>
- <refpurpose>
- Returns the type name for the corresponding field number
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-fieldtype">
+ <refnamediv>
+ <refname>pg_fieldtype</refname>
+ <refpurpose>
+ 주어진 필드번호에 해당하는 데이터형을 돌려준다.
</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>string <function>pg_fieldtype</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- <paramdef>int <parameter>field_number</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_fieldtype</function> will return a string containing
- the type name of the given field in the given PostgreSQL result
- identifier. Field numbering starts at 0.
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-freeresult">
- <refnamediv>
- <refname>pg_freeresult</refname>
- <refpurpose>Free result memory</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_freeresult</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_freeresult</function> only needs to be called if you
- are worried about using too much memory while your script is
- running. All result memory will automatically be freed when the
- script is finished. But, if you are sure you are not going to
- need the result data anymore in a script, you may call
- <function>pg_freeresult</function> with the result identifier as
- an argument and the associated result memory will be freed.
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-getlastoid">
- <refnamediv>
- <refname>pg_getlastoid</refname>
- <refpurpose>Returns the last object identifier</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_getlastoid</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_getlastoid</function> can be used to retrieve the
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>string
+<function>pg_fieldtype</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ <paramdef>int
+<parameter>field_number</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_fieldtype</function> 함수는 PostgreSQL
+결과지시자가
+ 가리키는 필드의 데이터형을 돌려준다.
+필드번호는 0부터 매겨진다.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-freeresult">
+ <refnamediv>
+ <refname>pg_freeresult</refname>
+ <refpurpose>결과값을 저장했던 메모리를
+비운다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_freeresult</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_freeresult</function> 함수는
+여러분의 스크립트가 실행되고 있을때
+ 너무 많은 메모리 공간을 사용한다고
+판단될 경우 쓰일 수 있다. 실행 결과값을 담아두고
+ 있는 모든 메모리는 스크립트의 실행이
+끝났을때 자동적으로 비워지지만 만약 그 메모리에
+ 저장된 결과값이 더이상 필요없다고
+확신할 경우 그것에 해당하는 결과지시자를 인수로 넣어
+ 수동으로 메모리를 비워줄 수 있다.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-getlastoid">
+ <refnamediv>
+ <refname>pg_getlastoid</refname>
+ <refpurpose>마지막 오브젝트 지시자를
+돌려준다.</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_getlastoid</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_getlastoid</function> can be used to
+retrieve the
<varname>oid</varname> assigned to an inserted tuple if the
result identifier is used from the last command sent via
<function>pg_exec</function> and was an SQL INSERT. This
@@ -747,67 +755,70 @@
the last command sent via <function>pg_exec</function> was not an
INSERT.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-host">
- <refnamediv>
- <refname>pg_host</refname>
- <refpurpose>
- Returns the host name associated with the connection
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-host">
+ <refnamediv>
+ <refname>pg_host</refname>
+ <refpurpose>
+ 접속된 PostgreSQL 호스트의 주소를 돌려준다.
</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>string <function>pg_host</function></funcdef>
- <paramdef>int <parameter>connection_id</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_host</function> will return the host name of the
- given PostgreSQL connection identifier is connected to.
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-loclose">
- <refnamediv>
- <refname>pg_loclose</refname>
- <refpurpose>Close a large object</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>void <function>pg_loclose</function></funcdef>
- <paramdef>int <parameter>fd</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_loclose</function> closes an Inversion Large
+ </refnamediv>
+ <refsect1>
+ <title>함수 설명</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>string <function>pg_host</function>
+ </funcdef>
+ <paramdef>int
+<parameter>connection_id</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_host</function> 함수는 인수로
+주어진 PostgreSQL 접속지시자에
+ 해당하는 호스트의 이름을 돌려준다.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-loclose">
+ <refnamediv>
+ <refname>pg_loclose</refname>
+ <refpurpose>Close a large object</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>void <function>pg_loclose</function>
+ </funcdef>
+ <paramdef>int <parameter>fd</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_loclose</function> closes an Inversion
+Large
Object. <parameter>Fd</parameter> is a file descriptor for the
large object from <function>pg_loopen</function>.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-locreate">
- <refnamediv>
- <refname>pg_locreate</refname>
- <refpurpose>Create a large object</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_locreate</function></funcdef>
- <paramdef>int <parameter>conn</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_locreate</function> creates an Inversion Large
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-locreate">
+ <refnamediv>
+ <refname>pg_locreate</refname>
+ <refpurpose>Create a large object</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_locreate</function>
+ </funcdef>
+ <paramdef>int <parameter>conn</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_locreate</function> creates an Inversion
+Large
Object and returns the <varname>oid</varname> of the large
object. <parameter>conn</parameter> specifies a valid database
connection. PostgreSQL access modes INV_READ, INV_WRITE, and
@@ -815,31 +826,33 @@
both read and write access. INV_ARCHIVE has been removed from
PostgreSQL itself (version 6.3 and above).
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-loexport">
- <refnamediv>
- <refname>pg_loexport</refname>
- <refpurpose>Export a large object to file</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>bool <function>pg_loexport</function></funcdef>
- <paramdef>int
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-loexport">
+ <refnamediv>
+ <refname>pg_loexport</refname>
+ <refpurpose>Export a large object to file</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>bool <function>pg_loexport</function>
+ </funcdef>
+ <paramdef>int
<parameter>oid</parameter>
- </paramdef>
- <paramdef>int
+ </paramdef>
+ <paramdef>int
<parameter>file</parameter>
- </paramdef>
- <paramdef>int
- <parameter><optional>connection_id</optional></parameter>
- </paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
+ </paramdef>
+ <paramdef>int
+ <parameter>
+
+<optional>connection_id</optional>
+ </parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
The <parameter>oid</parameter> argument specifies the object id
of the large object to export and the
<parameter>filename</parameter> argument specifies the pathname
@@ -847,319 +860,339 @@
otherwise. Remember that handling large objects in PostgreSQL
must happen inside a transaction.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-loimport">
- <refnamediv>
- <refname>pg_loimport</refname>
- <refpurpose>Import a large object from file</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_loimport</function></funcdef>
- <paramdef>int
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-loimport">
+ <refnamediv>
+ <refname>pg_loimport</refname>
+ <refpurpose>Import a large object from file</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_loimport</function>
+ </funcdef>
+ <paramdef>int
<parameter>file</parameter>
- </paramdef>
- <paramdef>int
- <parameter><optional>connection_id</optional></parameter>
- </paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
+ </paramdef>
+ <paramdef>int
+ <parameter>
+
+<optional>connection_id</optional>
+ </parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
The <parameter>filename</parameter> argument specifies the
pathname of the file to be imported as a large object. Returns
FALSE if an error occurred, object id of the just created large
object otherwise. Remember that handling large objects in
PostgreSQL must happen inside a transaction.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-loopen">
- <refnamediv>
- <refname>pg_loopen</refname>
- <refpurpose>Open a large object</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_loopen</function></funcdef>
- <paramdef>int <parameter>conn</parameter></paramdef>
- <paramdef>int <parameter>objoid</parameter></paramdef>
- <paramdef>string <parameter>mode</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_loopen</function> open an Inversion Large Object and
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-loopen">
+ <refnamediv>
+ <refname>pg_loopen</refname>
+ <refpurpose>Open a large object</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_loopen</function>
+ </funcdef>
+ <paramdef>int <parameter>conn</parameter>
+ </paramdef>
+ <paramdef>int <parameter>objoid</parameter>
+ </paramdef>
+ <paramdef>string <parameter>mode</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_loopen</function> open an Inversion Large
+Object and
returns file descriptor of the large object. The file descriptor
encapsulates information about the connection. Do not close the
connection before closing the large object file descriptor.
<parameter>objoid</parameter> specifies a valid large object oid
and <parameter>mode</parameter> can be either "r", "w", or "rw".
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-loread">
- <refnamediv>
- <refname>pg_loread</refname>
- <refpurpose>Read a large object</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>string <function>pg_loread</function></funcdef>
- <paramdef>int <parameter>fd</parameter></paramdef>
- <paramdef>int <parameter>len</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>pg_loread</function> reads at most
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-loread">
+ <refnamediv>
+ <refname>pg_loread</refname>
+ <refpurpose>Read a large object</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>string <function>pg_loread</function>
+ </funcdef>
+ <paramdef>int <parameter>fd</parameter>
+ </paramdef>
+ <paramdef>int <parameter>len</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>pg_loread</function> reads at most
<parameter>len</parameter> bytes from a large object and
returns it as a string.
<parameter>fd</parameter> specifies a valid large object file
descriptor and<parameter>len</parameter> specifies the maximum
allowable size of the large object segment.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-loreadall">
- <refnamediv>
- <refname>pg_loreadall</refname>
- <refpurpose>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-loreadall">
+ <refnamediv>
+ <refname>pg_loreadall</refname>
+ <refpurpose>
Read a entire large object and send straight to browser
</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>void <function>pg_loreadall</function></funcdef>
- <paramdef>int <parameter>fd</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_loreadall</function> reads a large object and
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>void <function>pg_loreadall</function>
+ </funcdef>
+ <paramdef>int <parameter>fd</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_loreadall</function> reads a large object
+and
passes it straight through to the browser after sending all pending
headers. Mainly intended for sending binary data like images or sound.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-lounlink">
- <refnamediv>
- <refname>pg_lounlink</refname>
- <refpurpose>Delete a large object</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>void <function>pg_lounlink</function></funcdef>
- <paramdef>int <parameter>conn</parameter></paramdef>
- <paramdef>int <parameter>lobjid</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_lounlink</function> deletes a large object with the
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-lounlink">
+ <refnamediv>
+ <refname>pg_lounlink</refname>
+ <refpurpose>Delete a large object</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>void <function>pg_lounlink</function>
+ </funcdef>
+ <paramdef>int <parameter>conn</parameter>
+ </paramdef>
+ <paramdef>int <parameter>lobjid</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_lounlink</function> deletes a large
+object with the
<parameter>lobjid</parameter> identifier for that large object.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-lowrite">
- <refnamediv>
- <refname>pg_lowrite</refname>
- <refpurpose>Write a large object</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_lowrite</function></funcdef>
- <paramdef>int <parameter>fd</parameter></paramdef>
- <paramdef>string <parameter>buf</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_lowrite</function> writes at most to a large object
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-lowrite">
+ <refnamediv>
+ <refname>pg_lowrite</refname>
+ <refpurpose>Write a large object</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_lowrite</function>
+ </funcdef>
+ <paramdef>int <parameter>fd</parameter>
+ </paramdef>
+ <paramdef>string <parameter>buf</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_lowrite</function> writes at most to a
+large object
from a variable <parameter>buf</parameter> and returns the number
of bytes actually written, or false in the case of an error.
<parameter>fd</parameter> is a file descriptor for the large
object from <function>pg_loopen</function>.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-numfields">
- <refnamediv>
- <refname>pg_numfields</refname>
- <refpurpose>Returns the number of fields</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_numfields</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_numfields</function> will return the number of
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-numfields">
+ <refnamediv>
+ <refname>pg_numfields</refname>
+ <refpurpose>Returns the number of fields</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_numfields</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_numfields</function> will return the
+number of
fields (columns) in a PostgreSQL result. The argument is a valid
result identifier returned by <function>pg_exec</function>. This
function will return -1 on error.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-numrows">
- <refnamediv>
- <refname>pg_numrows</refname>
- <refpurpose>Returns the number of rows</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_numrows</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_numrows</function> will return the number of rows in a
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-numrows">
+ <refnamediv>
+ <refname>pg_numrows</refname>
+ <refpurpose>Returns the number of rows</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_numrows</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_numrows</function> will return the number
+of rows in a
PostgreSQL result. The argument is a valid result identifier
returned by <function>pg_exec</function>. This function will
return -1 on error.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-options">
- <refnamediv>
- <refname>pg_options</refname>
- <refpurpose>Get the options associated with the connection</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>string <function>pg_options</function></funcdef>
- <paramdef>int <parameter>connection_id</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_options</function> will return a string containing
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-options">
+ <refnamediv>
+ <refname>pg_options</refname>
+ <refpurpose>Get the options associated with the
+connection</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>string <function>pg_options</function>
+ </funcdef>
+ <paramdef>int
+<parameter>connection_id</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_options</function> will return a string
+containing
the options specified on the given PostgreSQL connection
identifier.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-pconnect">
- <refnamediv>
- <refname>pg_pconnect</refname>
- <refpurpose>Open a persistant PostgreSQL connection</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_pconnect</function></funcdef>
- <paramdef>string <parameter>conn_string</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-pconnect">
+ <refnamediv>
+ <refname>pg_pconnect</refname>
+ <refpurpose>Open a persistant PostgreSQL
+connection</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_pconnect</function>
+ </funcdef>
+ <paramdef>string
+<parameter>conn_string</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
Returns a connection index on success, or false if the connection
could not be made. Opens a connection to a PostgreSQL database.
The arguments should be within a quoted string.
- The arguments available include <parameter>dbname</parameter>
- <parameter>port</parameter>, <parameter>host</parameter>,
+ The arguments available include <parameter>dbname</parameter>
+ <parameter>port</parameter>,
+<parameter>host</parameter>,
<parameter>tty</parameter>, <parameter>options</parameter>,
<parameter>user</parameter>, and <parameter>password</parameter>
- </para>
- <para>
+ </para>
+ <para>
This function returns a connection index that is needed by other
PostgreSQL functions. You can have multiple connections open at
once.
</para>
- <para>
+ <para>
The previous syntax of:
<command>$conn = pg_pconnect ("host", "port", "options", "tty",
"dbname")
</command>
has been deprecated.
</para>
- <para>
+ <para>
See also <function>pg_connect</function>.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-port">
- <refnamediv>
- <refname>pg_port</refname>
- <refpurpose>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-port">
+ <refnamediv>
+ <refname>pg_port</refname>
+ <refpurpose>
Return the port number associated with the connection
</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_port</function></funcdef>
- <paramdef>int <parameter>connection_id</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_port</function> will return the port number that the
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int <function>pg_port</function>
+ </funcdef>
+ <paramdef>int
+<parameter>connection_id</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_port</function> will return the port
+number that the
given PostgreSQL connection identifier is connected to.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-put-line">
- <refnamediv>
- <refname>pg_put_line</refname>
- <refpurpose>Send a NULL-terminated string to PostgreSQL backend</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>bool <function>pg_put_line</function></funcdef>
- <paramdef>resource
- <parameter><optional>connection_id</optional></parameter>
- </paramdef>
- <paramdef>string <parameter>data</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>pg_put_line</function> sends a NULL-terminated string
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-put-line">
+ <refnamediv>
+ <refname>pg_put_line</refname>
+ <refpurpose>Send a NULL-terminated string to PostgreSQL
+backend</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>bool <function>pg_put_line</function>
+ </funcdef>
+ <paramdef>resource
+ <parameter>
+
+<optional>connection_id</optional>
+ </parameter>
+ </paramdef>
+ <paramdef>string <parameter>data</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>pg_put_line</function> sends a
+NULL-terminated string
to the PostgreSQL backend server. This is useful for example for
very high-speed inserting of data into a table, initiated by
starting a PostgreSQL copy-operation. That final NULL-character
is added automatically. Returns TRUE if successfull, FALSE
otherwise.
</para>
- <note>
- <para>
+ <note>
+ <para>
Note the application must explicitly send the two characters "\."
on a final line to indicate to the backend that it has finished
sending its data.
</para>
- </note>
- <para>
+ </note>
+ <para>
See also <function>pg_end_copy</function>.
<example>
- <title>High-speed insertion of data into a table</title>
- <programlisting role="php">
+ <title>High-speed insertion of data into a
+table</title>
+ <programlisting role="php">
<?php
$conn = pg_pconnect ("dbname=foo");
pg_exec($conn, "create table bar (a int4, b char(16), d float8)");
@@ -1170,28 +1203,31 @@
pg_end_copy($conn);
?>
</programlisting>
- </example>
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-result">
- <refnamediv>
- <refname>pg_result</refname>
- <refpurpose>Returns values from a result identifier</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>mixed <function>pg_result</function></funcdef>
- <paramdef>int <parameter>result_id</parameter></paramdef>
- <paramdef>int <parameter>row_number</parameter></paramdef>
- <paramdef>mixed <parameter>fieldname</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_result</function> will return values from a result
+ </example>
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-result">
+ <refnamediv>
+ <refname>pg_result</refname>
+ <refpurpose>Returns values from a result
+identifier</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>mixed <function>pg_result</function>
+ </funcdef>
+ <paramdef>int <parameter>result_id</parameter>
+ </paramdef>
+ <paramdef>int <parameter>row_number</parameter>
+ </paramdef>
+ <paramdef>mixed
+<parameter>fieldname</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_result</function> will return values from
+a result
identifier produced by <function>pg_Exec</function>. The
<parameter>row_number</parameter> and
<parameter>fieldname</parameter> sepcify what cell in the table
@@ -1199,7 +1235,7 @@
naming the field, you may use the field index as an unquoted
number. Field indices start from 0.
</para>
- <para>
+ <para>
PostgreSQL has many built in types and only the basic ones are
directly supported here. All forms of integer, boolean and oid
types are returned as integer values. All forms of float, and
@@ -1207,117 +1243,126 @@
including arrays are returned as strings formatted in the same
default PostgreSQL manner that you would see in the
<command>psql</command> program.
- </para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-set-client-encoding">
- <refnamediv>
- <refname>pg_set_client_encoding</refname>
- <refpurpose>
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-set-client-encoding">
+ <refnamediv>
+ <refname>pg_set_client_encoding</refname>
+ <refpurpose>
Set the client encoding
</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>int <function>pg_set_client_encoding</function></funcdef>
- <paramdef>int
- <parameter><optional>connection</optional></parameter>
- </paramdef>
- <paramdef>string <parameter>encoding</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>int
+<function>pg_set_client_encoding</function>
+ </funcdef>
+ <paramdef>int
+ <parameter>
+ <optional>connection</optional>
+ </parameter>
+ </paramdef>
+ <paramdef>string
+<parameter>encoding</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
The function set the client encoding and return 0 if success or
-1 if error.
</para>
- <para>
- <parameter>encoding</parameter> is the client
+ <para>
+ <parameter>encoding</parameter> is the client
encoding and can be either :
SQL_ASCII, EUC_JP, EUC_CN, EUC_KR, EUC_TW, UNICODE,
MULE_INTERNAL, LATINX (X=1...9), KOI8, WIN, ALT,
SJIS, BIG5, WIN1250.
</para>
- <note>
- <para>
+ <note>
+ <para>
This function requires PHP-4.0.2 or higher and PostgreSQL-7.0 or
higher.
</para>
- <para>
+ <para>
The function used to be called
<function>pg_setclientencoding</function>.
</para>
- </note>
- <para>
+ </note>
+ <para>
See also <function>pg_client_encoding</function>.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-client-encoding">
- <refnamediv>
- <refname>pg_client_encoding</refname>
- <refpurpose>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-client-encoding">
+ <refnamediv>
+ <refname>pg_client_encoding</refname>
+ <refpurpose>
Get the client encoding
</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>string <function>pg_client_encoding</function></funcdef>
- <paramdef>int
- <parameter><optional>connection</optional></parameter>
- </paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>string
+<function>pg_client_encoding</function>
+ </funcdef>
+ <paramdef>int
+ <parameter>
+ <optional>connection</optional>
+ </parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
The functions returns the client encoding as the string. The
returned string should be either :
SQL_ASCII, EUC_JP, EUC_CN, EUC_KR, EUC_TW, UNICODE,
MULE_INTERNAL, LATINX (X=1...9), KOI8, WIN, ALT,
SJIS, BIG5, WIN1250.
</para>
- <note>
- <para>
+ <note>
+ <para>
This function requires PHP-4.0.2 or higher and PostgreSQL-7.0 or
higher.
</para>
- <para>
+ <para>
The function used to be called
<function>pg_clientencoding</function>.
</para>
- </note>
- <para>
+ </note>
+ <para>
See also <function>pg_set_client_encoding</function>.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-trace">
- <refnamediv>
- <refname>pg_trace</refname>
- <refpurpose>Enable tracing a PostgreSQL connection</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>bool <function>pg_trace</function></funcdef>
- <paramdef>string
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-trace">
+ <refnamediv>
+ <refname>pg_trace</refname>
+ <refpurpose>Enable tracing a PostgreSQL connection</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>bool <function>pg_trace</function>
+ </funcdef>
+ <paramdef>string
<parameter>filename</parameter>
- </paramdef>
- <paramdef>string
- <parameter><optional>mode</optional></parameter>
- </paramdef>
- <paramdef>int
- <parameter><optional>connection</optional></parameter>
- </paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
+ </paramdef>
+ <paramdef>string
+ <parameter>
+ <optional>mode</optional>
+ </parameter>
+ </paramdef>
+ <paramdef>int
+ <parameter>
+ <optional>connection</optional>
+ </parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
Enables tracing of the PostgreSQL frontend/backend communication
to a debugging file. To fully understand the results one needs to
be familiar with the internals of PostgreSQL communication
@@ -1326,78 +1371,79 @@
example <command>grep '^To backend' trace.log</command> and see
what query actually were sent to the PostgreSQL server.
</para>
- <para>
- <parameter>Filename</parameter> and <parameter>mode</parameter>
+ <para>
+ <parameter>Filename</parameter> and
+<parameter>mode</parameter>
are the same as in <function>fopen</function>
(<parameter>mode</parameter> defaults to 'w'),
<parameter>connection</parameter> specifies the connection to
trace and defaults to the last one opened.
</para>
- <para>
+ <para>
Returns TRUE if <parameter>filename</parameter> could be opened
for logging, FALSE otherwise.
</para>
- <para>
+ <para>
See also <function>fopen</function> and
<function>pg_untrace</function>.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-tty">
- <refnamediv>
- <refname>pg_tty</refname>
- <refpurpose>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-tty">
+ <refnamediv>
+ <refname>pg_tty</refname>
+ <refpurpose>
Return the tty name associated with the connection
</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>string <function>pg_tty</function></funcdef>
- <paramdef>int <parameter>connection_id</parameter></paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
- <function>Pg_tty</function> will return the tty name that server
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>string <function>pg_tty</function>
+ </funcdef>
+ <paramdef>int
+<parameter>connection_id</parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
+ <function>Pg_tty</function> will return the tty name
+that server
side debugging output is sent to on the given PostgreSQL
connection identifier.
</para>
- </refsect1>
- </refentry>
-
- <refentry id="function.pg-untrace">
- <refnamediv>
- <refname>pg_untrace</refname>
- <refpurpose>Disable tracing of a PostgreSQL connection</refpurpose>
- </refnamediv>
- <refsect1>
- <title>Description</title>
- <funcsynopsis>
- <funcprototype>
- <funcdef>bool <function>pg_untrace</function></funcdef>
- <paramdef>int
- <parameter><optional>connection</optional></parameter>
- </paramdef>
- </funcprototype>
- </funcsynopsis>
- <para>
+ </refsect1>
+ </refentry>
+ <refentry id="function.pg-untrace">
+ <refnamediv>
+ <refname>pg_untrace</refname>
+ <refpurpose>Disable tracing of a PostgreSQL
+connection</refpurpose>
+ </refnamediv>
+ <refsect1>
+ <title>Description</title>
+ <funcsynopsis>
+ <funcprototype>
+ <funcdef>bool <function>pg_untrace</function>
+ </funcdef>
+ <paramdef>int
+ <parameter>
+ <optional>connection</optional>
+ </parameter>
+ </paramdef>
+ </funcprototype>
+ </funcsynopsis>
+ <para>
Stop tracing started by <function>pg_trace</function>.
<parameter>connection</parameter> specifies the connection that was
traced and defaults to the last one opened.
</para>
- <para>
+ <para>
Returns always TRUE.
</para>
- <para>
+ <para>
See also <function>pg_trace</function>.
</para>
- </refsect1>
- </refentry>
-
- </reference>
-
+ </refsect1>
+ </refentry>
+</reference>
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
