v5:database:postgresql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:database:postgresql [2016/01/13 01:53] – ↷ Page moved from database:postgresql to v5:database:postgresql 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 ====== | ====== PostgreSQL ====== | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
- | ===== postgres9 | + | |
+ | <WRAP info> | ||
+ | The PostgreSQL drivers are currently undergoing a [[https:// | ||
+ | |||
+ | At the end of this process, there will be a single // | ||
+ | </ | ||
+ | |||
+ | ===== 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: | ||
</ | </ | ||
- | This driver | + | **This is the preferred |
+ | |||
+ | <WRAP tip> | ||
+ | '' | ||
+ | </ | ||
==== Driver Specific Options ==== | ==== Driver Specific Options ==== | ||
+ | |||
None | None | ||
+ | |||
+ | ==== Using Geometry DataTypes ==== | ||
+ | |||
+ | As of v5.21, ADOdb provides the: | ||
+ | * [[v5: | ||
+ | * [[v5: | ||
+ | |||
------------------------------- | ------------------------------- | ||
+ | |||
==== Example Connection Strings ===== | ==== Example Connection Strings ===== | ||
+ | |||
<code php> | <code php> | ||
- | $db->Connect(" | + | $db->connect(" |
- | $db->Connect(null, $user=' | + | $db->connect(null, $user=' |
</ | </ | ||
+ | |||
+ | |||
+ | ===== 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> | ||
- | |||
- | ===== 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| | ||
- | </ | ||
- | This community provided driver is built on the [[database: | ||
- | {{tag> | ||
+ | {{tag> | ||
v5/database/postgresql.1452646420.txt.gz · Last modified: 2017/04/21 11:51 (external edit)