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 [2017/04/21 11:49] – external edit 127.0.0.1v5: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 ==
 ^Driver Name|postgres9| ^Driver Name|postgres9|
-^Data Provider|postgres64|+^Data Provider|postgres|
 ^Status|Active((This driver is actively supported by ADOdb project members))| ^Status|Active((This driver is actively supported by ADOdb project members))|
 ^Windows|Yes| ^Windows|Yes|
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: 
 +  * [[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 34: 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]}}+{{tag>[postgres supported tier1]}}
  
v5/database/postgresql.1492768188.txt.gz · Last modified: 2017/04/21 11:49 by 127.0.0.1