ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
v5:database:postgresql [2016/02/28 17:29] – [postgres9] mnewnhamv5:database:postgresql [2022/07/13 03:09] mnewnham
Line 5: Line 5:
 == Specification == == Specification ==
 ^Driver Name|postgres9| ^Driver Name|postgres9|
-^Data Provider|postgres64|+^Data Provider|postgres|
 ^Status|Active((This driver is actively supported by ADOdb project members))| ^Status|Active((This driver is actively supported by ADOdb project members))|
 ^Windows|Yes| ^Windows|Yes|
Line 13: Line 13:
 == Alternatives == == Alternatives ==
 [[v5:database:pdo#pdo_pgsql|PDO Driver For PostgreSQL]] [[v5:database:pdo#pdo_pgsql|PDO Driver For PostgreSQL]]
 +
 </WRAP> </WRAP>
  
Line 18: Line 19:
 ==== Driver Specific Options ==== ==== Driver Specific Options ====
 None None
 +==== Using Geometry DataTypes ====
 +As of V5.21:
 +  * ADOdb provides a constant, [[v5:reference:adodb_default_metatype|ADODB_DEFAULT_METATYPE]], that assists in the use of Geometry Data Types. 
 +  * The [[v5:reference:connection:setCustomMetaType|setCustomMetaType()]] method allows the creation of Geometry types
 +
 ------------------------------- -------------------------------
 +
 ==== Example Connection Strings ===== ==== Example Connection Strings =====
 <code php> <code php>
-$db->Connect("host=host1 user=user1 password=secret port=4341"); +$db->connect("host=host1 user=user1 password=secret port=4341"); 
-$db->Connect(null, $user='user1' $password='secret');+$db->connect(null, $user='user1'$password='secret');
 </code> </code>
  
Line 38: Line 45:
  
  
-{{tag>[postgres supported]}} +{{tag>[postgres supported tier1]}}
- +
-===== netezza===== +
-<WRAP right box round 300px> +
-== Specification == +
-^Driver Name|netezza| +
-^Data Provider|postgres64| +
-^Status|Obsolete((This driver is unsupported and will be removed in ADOdb V6))| +
-^Windows|Yes| +
-^Unix|Yes| +
-^ADOdb V5|Yes| +
-^ADOdb V6|No| +
-</WRAP> +
-This community provided driver is built on the [[v5:database:postgresql]] driver. Its status and quality are unknown.  +
-{{tag>[netzza deprecated]}} +
  
v5/database/postgresql.txt · Last modified: 2023/11/05 01:18 by dregad