Differences

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

--- database:postgresql [2015/11/26 22:59] – created 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|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 PostgreSQL databases version 8 and above.**
+<WRAP tip>
+''postgres'' and ''pgsql'' are actually aliases for the //postgres9// driver.
+</WRAP>
+==== Driver Specific Options ====
+None
+==== Using Geometry DataTypes ====
+As of v5.21, ADOdb provides the:
+  * [[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
+-------------------------------
+==== Example Connection Strings =====
+<code php>
+$db->connect("host=host1 user=user1 password=secret port=4341");
+$db->connect(null, $user='user1', $password='secret');
+</code>
+===== postgres9 =====
+This is the latest available driver, supporting all PostgreSQL releases since version 8.
+===== 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
+{{tag>[postgres supported tier1]}}