====== PostgreSQL ======
~~NOTOC~~

<WRAP info>
The PostgreSQL drivers are currently undergoing a [[https://github.com/ADOdb/ADOdb/issues/955|major refactoring]], targeted at upcoming release 5.23.0.

At the end of this process, there will be a single //postgres// driver instead of multiple, version-specific ones, which does not make sense anymore as they are all targeting versions of the database that have been obsolete and unsupported for many years.
</WRAP>

===== postgres / pgsql =====

<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 ==
[[v5:database:pdo#pdo_pgsql|PDO Driver For PostgreSQL]]
</WRAP>

**This is the preferred driver for connections to PostgreSQL databases version 8 and above.**

<WRAP tip>
''postgres'' and ''pgsql'' are actually aliases for the //postgres9// driver.
</WRAP>

==== Driver Specific Options ====

None

==== Using Geometry DataTypes ====

As of v5.21, ADOdb provides the:
  * [[v5:reference:adodb_default_metatype|ADODB_DEFAULT_METATYPE]] constant, that assists in the use of Geometry Data Types. 
  * [[v5:reference:connection:setCustomMetaType|setCustomMetaType()]] method that allows the creation of Geometry types

-------------------------------

==== Example Connection Strings =====

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


===== postgres9 =====
This is the latest available driver, supporting all PostgreSQL releases since version 8.

===== 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


{{tag>[postgres supported tier1]}}