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
This is the preferred driver for connections to PostgreSQL databases version 8 and above.
pgsql are actually aliases for the postgres9 driver.
Driver Specific Options
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');
This is the latest available driver, supporting all PostgreSQL releases since version 8.
This driver is exactly the same as postgres9
This driver provides connections to PostgreSQL version 7 databases
This driver provides connections to PostgreSQL version 6.4 databases