ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:postgresql

This is an old revision of the document!


PostgreSQL

postgres9

Specification
Driver Namepostgres9
Data Providerpostgres64
StatusActive1)
WindowsYes
UnixNo
ADOdb V5Yes
ADOdb V6Yes
Alternatives

PDO Driver For PostgreSQL

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

Driver Specific Options

None

Using Geometry DataTypes

As of V5.21, ADOdb provides a constant, ADODB_DEFAULT_METATYPE, that assists in the use of Geometry Data Types.


Example Connection Strings

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

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

This driver provides connections to PostgreSQL databases below version 6.4

netezza

Specification
Driver Namenetezza
Data Providerpostgres64
StatusObsolete2)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6No

This community provided driver is built on the PostgreSQL driver. Its status and quality are unknown.

1)
This driver is actively supported by ADOdb project members
2)
This driver is unsupported and will be removed in ADOdb V6
v5/database/postgresql.1456677270.txt.gz · Last modified: 2017/04/21 11:23 (external edit)