ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:postgresql

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 Namepostgres9
Data Providerpostgres
StatusActive1)
WindowsYes
UnixNo
ADOdb V5Yes
ADOdb V6Yes
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:


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

1)
This driver is actively supported by ADOdb project members
v5/database/postgresql.txt · Last modified: 2023/11/05 01:18 by dregad