Differences

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

--- database:postgresql [2015/11/26 23:06] – mnewnham
+++ v5:database:postgresql [2022/07/13 03:09] – mnewnham
@@ Line 1: / Line 1: @@
 ====== PostgreSQL ======
 ~~NOTOC~~
-<WRAP right box round>
+===== postgres9 =====
-== Alternative Driver ==
+<WRAP right box round 300px>
-[[database:pdo#pdo_pgsql|PDO Driver For PostgreSQL]]
+== Specification ==
+^Driver Name|postgres9|
+^Data Provider|postgres|
+^Status|Active((This driver is actively supported by ADOdb project members))|
+^Windows|Yes|
+^Unix|No|
+^ADOdb V5|Yes|
+^ADOdb V6|Yes|
+== Alternatives ==
+[[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**
-===== Support Status =====
+==== Driver Specific Options ====
-This driver is actively supported by ADOdb project members
-===== Specification ======
-|Driver Name|postgres9|
-|Status|Active|
-|Supported OS|Windows,Unix|
-|Other name|postgres8|
-===== 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(null, $user='user1', $password='secret');
+</code>
-===== Other Drivers ====
+===== postgres8 =====
-==== postgres8 ====
 This driver is exactly the same as postgres9
-==== postgres7 ====
+===== postgres7 =====
 This driver provides connections to PostgreSQL version 7 databases
@@ Line 32: / Line 45: @@
-{{tag>[postgres supported]}}
+{{tag>[postgres supported tier1]}}