Differences

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

--- database:postgresql [2015/11/26 22:59] – created mnewnham
+++ v5:database:postgresql [2022/07/13 03:09] – mnewnham
@@ Line 1: / Line 1: @@
 ====== PostgreSQL ======
+~~NOTOC~~
+===== postgres9 =====
+<WRAP right box round 300px>
+== 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 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(null, $user='user1', $password='secret');
+</code>
+===== 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
+{{tag>[postgres supported tier1]}}