Differences

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

--- database:postgresql [2015/11/28 16:13] – mnewnham
+++ v5:database:postgresql [2022/07/13 03:09] – mnewnham
@@ Line 5: / Line 5: @@
 == Specification ==
 ^Driver Name|postgres9|
-^Data Provider|postgres64|
+^Data Provider|postgres|
 ^Status|Active((This driver is actively supported by ADOdb project members))|
 ^Windows|Yes|
@@ Line 12: / Line 12: @@
 ^ADOdb V6|Yes|
 == Alternatives ==
-[[database:pdo#pdo_pgsql|PDO Driver For PostgreSQL]]
+[[v5:database:pdo#pdo_pgsql|PDO Driver For PostgreSQL]]
 </WRAP>
-This driver provides a connection to a Postgres databases version 8 and above
+**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, [[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 =====
 <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>
@@ 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 [[database:Postgresql]] driver. Its status and quality are unknown.
-{{tag>[netzza deprecated]}}