Differences

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

--- database:postgresql [2015/11/27 00:04] – 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 right box round>
-== Alternative Driver ==
+<WRAP info>
-[[database:pdo#pdo_pgsql|PDO Driver For PostgreSQL]]
+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>
-This driver provides a connection to a Postgres databases version 8 and above
+===== postgres / pgsql =====
-===== Support Status =====
-This driver is actively supported by ADOdb project members
+<WRAP right box round 300px>
-===== Specification ======
+== Specification ==
-|Driver Name|postgres9|
+^Driver Name|postgres9|
-|Status|Active|
+^Data Provider|postgres|
-|Supported OS|Windows,Unix|
+^Status|Active((This driver is actively supported by ADOdb project members))|
-|Other name|postgres8|
+^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 PostgreSQL databases version 8 and above.**
+<WRAP tip>
+''postgres'' and ''pgsql'' are actually aliases for the //postgres9// driver.
+</WRAP>
+==== Driver Specific Options ====
-===== 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 left 300px box>
+This is the latest available driver, supporting all PostgreSQL releases since version 8.
-|Driver Name|netezza|
-|Status|Deprecated|
+===== postgres8 =====
-|Windows|Unknown|
+This driver is exactly the same as postgres9
-|Unix|Unknown|
-</WRAP>
+===== postgres7 =====
-This community provided driver is built on the [[Postgres]] driver. Its status and quality are unknown.
+This driver provides connections to PostgreSQL version 7 databases
-{{tag>[netzza deprecated]}}
+===== postgres64 =====
+This driver provides connections to PostgreSQL version 6.4 databases
+{{tag>[postgres supported tier1]}}