yohgaki Sat Apr 6 23:53:56 2002 EDT
Modified files:
/phpdoc/en/functions pgsql.xml
Log:
Add more description for setting defaults via. env vars
Index: phpdoc/en/functions/pgsql.xml
diff -u phpdoc/en/functions/pgsql.xml:1.74 phpdoc/en/functions/pgsql.xml:1.75
--- phpdoc/en/functions/pgsql.xml:1.74 Sat Apr 6 23:37:56 2002
+++ phpdoc/en/functions/pgsql.xml Sat Apr 6 23:53:56 2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.74 $ -->
+<!-- $Revision: 1.75 $ -->
<reference id="ref.pgsql">
<title>PostgreSQL functions</title>
<titleabbrev>PostgreSQL</titleabbrev>
@@ -165,6 +165,28 @@
to version. Refer to PostgreSQL Programmer's Manual (libpq -
Environment Variables) for details.
</para>
+ <para>
+ Make sure you set environment variables for appropriate user. Use
+ <literal>$_ENV</literal> or <function>getenv</function> to check
+ environment variables available to current process.
+ </para>
+ <example>
+ <title>Setting default parameters</title>
+ <programlisting role="php">
+<![CDATA[
+PGHOST=psgql.exmaple.com
+PGPORT=7890
+PGDATABASE=web-system
+PGUSER=web-user
+PGPASSWORD=secret
+PGDATESTYLE=ISO
+PGTZ=JST
+PGCLIENTENCODING=EUC-JP
+
+export PGHOST PGPORT PGDATABASE PGUSER PGPASSWORD PGDATESTYLE PGTZ PGCLIENTENCODING
+]]>
+ </programlisting>
+ </example>
<para>
From PostgreSQL 7.1.0, text data type has 1GB as its max
size. Older PostgreSQL's text data type is limited by block
