ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:postgresql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
v5:database:postgresql [2021/03/14 01:16] – [Using Geometry DataTypes] mnewnhamv5:database:postgresql [2023/11/05 01:18] (current) – Add note about refactoring, postgres/pgsql aliases, reorganize page dregad
Line 1: Line 1:
 ====== PostgreSQL ====== ====== PostgreSQL ======
 ~~NOTOC~~ ~~NOTOC~~
-===== postgres9 =====+ 
 +<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> <WRAP right box round 300px>
 == Specification == == Specification ==
Line 15: Line 23:
 </WRAP> </WRAP>
  
-**This is the preferred driver for connections to Postgres databases version 8 and above**+**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 None
 +
 ==== Using Geometry DataTypes ==== ==== 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.  +As of v5.21, ADOdb provides the
-  * The [[v5:reference:connection:setCustomMetaType|setCustomMetaType()]] method allows the creation of Geometry types+  * [[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 ===== ==== Example Connection Strings =====
 +
 <code php> <code php>
 $db->connect("host=host1 user=user1 password=secret port=4341"); $db->connect("host=host1 user=user1 password=secret port=4341");
 $db->connect(null, $user='user1', $password='secret'); $db->connect(null, $user='user1', $password='secret');
 </code> </code>
 +
 +
 +===== postgres9 =====
 +This is the latest available driver, supporting all PostgreSQL releases since version 8.
  
 ===== postgres8 ===== ===== postgres8 =====
Line 37: Line 58:
 This driver provides connections to PostgreSQL version 7 databases This driver provides connections to PostgreSQL version 7 databases
  
-==== postgres64 ==== +===== postgres64 =====
 This driver provides connections to PostgreSQL version 6.4 databases 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]}} {{tag>[postgres supported tier1]}}
  
v5/database/postgresql.1615681010.txt.gz · Last modified: 2021/03/14 01:16 by mnewnham