====== PostgreSQL ======
~~NOTOC~~
===== postgres9 =====
<WRAP right box round 300px>
== Specification ==
^Driver Name|postgres9|
^Data Provider|postgres|
^Status|Active((This driver is actively supported by ADOdb project members))|
^Windows|Yes|
^Unix|No|
^ADOdb V5|Yes|
^ADOdb V6|Yes|
== Alternatives ==
[[v6:database:pdo#pdo_pgsql|PDO Driver For PostgreSQL]]
</WRAP>

**This is the preferred driver for connections to Postgres databases version 8 and above**
==== Driver Specific Options ====
None
==== Using Geometry DataTypes ====
As of V5.21, ADOdb provides a constant, [[v6:reference:adodb_default_metatype|ADODB_DEFAULT_METATYPE]], that assists in the use of Geometry Data Types.
-------------------------------

==== Example Connection Strings =====
<code php>
$db->connect("host=host1 user=user1 password=secret port=4341");
$db->connect(null, $user='user1', $password='secret');
</code>

===== postgres8 =====
This driver is exactly the same as postgres9

===== postgres7 ===== 
This driver provides connections to PostgreSQL version 7 databases

==== postgres64 ==== 
This driver provides connections to PostgreSQL version 6.4 databases

==== postgres ==== 
This driver provides connections to PostgreSQL databases below version 6.4


{{tag>postgres supported tier1 v6}}