reference/pdo_pgsql/reference.xml
ce612fcdfb5bebeaa7ebe7a0907a990d55e339d2
...
...
@@ -1,7 +1,7 @@
1
1
<?xml version="1.0" encoding="utf-8"?>
2
2
<!-- $Revision$ -->
3
3

4
-
<reference xml:id="ref.pdo-pgsql" xmlns="http://docbook.org/ns/docbook">
4
+
<reference xml:id="ref.pdo-pgsql" xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink">
5
5
<?phpdoc extension-membership="bundledexternal" ?>
6
6
<title>PostgreSQL Functions (PDO_PGSQL)</title>
7
7
<titleabbrev>PostgreSQL (PDO)</titleabbrev>
...
...
@@ -25,6 +25,16 @@
25
25
</section>
26
26

27
27
&reference.pdo-pgsql.configure;
28
+
&reference.pdo-pgsql.constants;
29
+

30
+
<section xml:id="pdo-pgsql.general-notes">
31
+
<title>General notes</title>
32
+
<note>
33
+
<para>
34
+
<literal>bytea</literal> fields are returned as streams.
35
+
</para>
36
+
</note>
37
+
</section>
28
38

29
39
</partintro>
30
40

...
...
@@ -91,14 +101,26 @@
91
101
</para>
92
102
</listitem>
93
103
</varlistentry>
104
+
<varlistentry>
105
+
<term><literal>sslmode</literal></term>
106
+
<listitem>
107
+
<para>
108
+
The SSL mode. Supported values and their meaning are listed in the
109
+
<link xlink:href="&url.pgsql.manual;">PostgreSQL Documentation</link>.
110
+
</para>
111
+
</listitem>
112
+
</varlistentry>
94
113

95
114
</variablelist>
115
+
<note>
116
+
<simpara>
117
+
All semicolons in the DSN string are replaced by spaces, because PostgreSQL
118
+
expects this format. This implies that semicolons in any of the components
119
+
(e.g. <literal>password</literal> or <literal>dbname</literal>) are not
120
+
supported.
121
+
</simpara>
122
+
</note>
96
123
</para>
97
-
<note>
98
-
<para>
99
-
The <literal>bytea</literal> fields are returned as streams.
100
-
</para>
101
-
</note>
102
124
</refsect1>
103
125
<refsect1 role="examples">
104
126
&reftitle.examples;
...
...
@@ -108,11 +130,21 @@
108
130
<para>
109
131
The following example shows a PDO_PGSQL DSN for connecting to
110
132
a PostgreSQL database:
111
-
<programlisting><![CDATA[
133
+
<programlisting>
134
+
<![CDATA[
112
135
pgsql:host=localhost;port=5432;dbname=testdb;user=bruce;password=mypass
113
136
]]>
114
137
</programlisting>
115
138
</para>
139
+
<para>
140
+
The following example shows a PDO_PGSQL DSN for connecting to
141
+
a PostgreSQL database via unix socket <filename>/tmp/.s.PGSQL.5432</filename>:
142
+
<programlisting>
143
+
<![CDATA[
144
+
pgsql:host=/tmp;port=5432;dbname=testdb;user=bruce;password=mypass
145
+
]]>
146
+
</programlisting>
147
+
</para>
116
148
</example>
117
149
</para>
118
150
</refsect1>
119
151