Differences

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

--- database:postgresql [2015/11/28 00:24] – mnewnham
+++ v5:database:postgresql [2023/11/05 01:18] (current) – Add note about refactoring, postgres/pgsql aliases, reorganize page dregad
@@ Line 1: / Line 1: @@
 ====== PostgreSQL ======
 ~~NOTOC~~
+<WRAP info>
+The PostgreSQL drivers are currently undergoing a [[https://github.com/ADOdb/ADOdb/issues/955|major refactoring]], targeted at upcoming release 5.23.0.
+At the end of this process, there will be a single //postgres// driver instead of multiple, version-specific ones, which does not make sense anymore as they are all targeting versions of the database that have been obsolete and unsupported for many years.
+</WRAP>
+===== postgres / pgsql =====
 <WRAP right box round 300px>
 == Specification ==
 ^Driver Name|postgres9|
-^Data Provider|postgres64|
+^Data Provider|postgres|
 ^Status|Active((This driver is actively supported by ADOdb project members))|
 ^Windows|Yes|
@@ Line 11: / Line 20: @@
 ^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 PostgreSQL databases version 8 and above.**
-===== Driver Specific Options =====
+<WRAP tip>
+''postgres'' and ''pgsql'' are actually aliases for the //postgres9// driver.
+</WRAP>
+==== Driver Specific Options ====
 None
-===== Other Drivers ====
+==== Using Geometry DataTypes ====
-==== postgres8 ====
-This driver is exactly the same as postgres9
-==== postgres7 ====
+As of v5.21, ADOdb provides the:
-This driver provides connections to PostgreSQL version 7 databases
+  * [[v5:reference:adodb_default_metatype|ADODB_DEFAULT_METATYPE]] constant, that assists in the use of Geometry Data Types.
+  * [[v5:reference:connection:setCustomMetaType|setCustomMetaType()]] method that allows the creation of Geometry types
-==== postgres64 ====
+-------------------------------
-This driver provides connections to PostgreSQL version 6.4 databases
-==== postgres ====
+==== Example Connection Strings =====
-This driver provides connections to PostgreSQL databases below version 6.4
+<code php>
+$db->connect("host=host1 user=user1 password=secret port=4341");
+$db->connect(null, $user='user1', $password='secret');
+</code>
-{{tag>[postgres supported]}}
-====== netezza======
+===== postgres9 =====
-<WRAP right box round 300px>
+This is the latest available driver, supporting all PostgreSQL releases since version 8.
-== Specification ==
-^Driver Name|netezza|
+===== postgres8 =====
-^Data Provider|postgres64|
+This driver is exactly the same as postgres9
-^Status|Obsolete((This driver is unsupported and will be removed in ADOdb V6))|
-^Windows|Yes|
+===== postgres7 =====
-^Unix|Yes|
+This driver provides connections to PostgreSQL version 7 databases
-^ADOdb V5|Yes|
-^ADOdb V6|No|
+===== postgres64 =====
-</WRAP>
+This driver provides connections to PostgreSQL version 6.4 databases
-This community provided driver is built on the [[database:Postgresql]] driver. Its status and quality are unknown.
-{{tag>[netzza deprecated]}}
+{{tag>[postgres supported tier1]}}