PostgreSQL

The PostgreSQL drivers are currently undergoing a 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.

postgres / pgsql

Specification

Driver Name	postgres9
Data Provider	postgres
Status	Active¹⁾
Windows	Yes
Unix	No
ADOdb V5	Yes
ADOdb V6	Yes

Alternatives

PDO Driver For PostgreSQL

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

postgres and pgsql are actually aliases for the postgres9 driver.

Driver Specific Options

None

Using Geometry DataTypes

As of v5.21, ADOdb provides the:

ADODB_DEFAULT_METATYPE constant, that assists in the use of Geometry Data Types.
setCustomMetaType() method that allows the creation of Geometry types

Example Connection Strings

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

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

postgres, supported, tier1

¹⁾

This driver is actively supported by ADOdb project members