cvs: phpdoc /kr/functions pgsql.xml
| From: | Jaemin Byon | Date: | Sun, 25 Feb 2001 17:48:21 +0000 |
| Subject: | cvs: phpdoc /kr/functions pgsql.xml | ||
| Groups: | php.doc | ||
| Request: | Send a blank email to phpdoc+get-969334469@lists.php.net to get a copy of this message | ||
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
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