ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
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 [2016/01/13 01:53] – ↷ Page moved from database:postgresql to v5:database:postgresql mnewnhamv5:database:postgresql [2025/06/01 13:21] (current) – Remove square brackets in tags 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 driver provides a connection to a 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 ====
 +
 +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 31: 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]}} 
- 
-===== netezza===== 
-<WRAP right box round 300px> 
-== Specification == 
-^Driver Name|netezza| 
-^Data Provider|postgres64| 
-^Status|Obsolete((This driver is unsupported and will be removed in ADOdb V6))| 
-^Windows|Yes| 
-^Unix|Yes| 
-^ADOdb V5|Yes| 
-^ADOdb V6|No| 
-</WRAP> 
-This community provided driver is built on the [[database:Postgresql]] driver. Its status and quality are unknown.  
-{{tag>[netzza deprecated]}} 
  
 +{{tag>postgres supported tier1}}
  
v5/database/postgresql.1452646420.txt.gz · Last modified: (external edit)