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 | Active1) |
| Windows | Yes |
| Unix | No |
| ADOdb V5 | Yes |
| ADOdb V6 | Yes |
Alternatives
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