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
database:postgresql [2015/11/26 23:06] 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~~
-<WRAP right info> + 
-== 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> </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 None
  
-===== Other Drivers ==== +==== Using Geometry DataTypes ==== 
-==== postgres8 ====+ 
 +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 This driver is exactly the same as postgres9
  
-==== postgres7 ==== +===== postgres7 ===== 
 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]}}+{{tag>[postgres supported tier1]}}
  
v5/database/postgresql.1448575570.txt.gz · Last modified: 2017/04/21 11:23 (external edit)