v5:database:postgresql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
database:postgresql [2015/11/26 23:06] – 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~~ | ||
- | < | + | |
- | == Alternative Driver == | + | <WRAP info> |
- | [[database:pdo# | + | The PostgreSQL drivers are currently undergoing a [[https:// |
+ | |||
+ | At the end of this process, there will be a single // | ||
</ | </ | ||
- | 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: | ||
+ | </ | ||
+ | |||
+ | **This is the preferred driver for connections to PostgreSQL databases version 8 and above.** | ||
+ | |||
+ | <WRAP tip> | ||
+ | '' | ||
+ | </ | ||
+ | |||
+ | ==== Driver Specific Options ==== | ||
- | ===== Driver Specific Options ===== | ||
None | None | ||
- | ===== Other Drivers | + | ==== Using Geometry DataTypes ==== |
- | ==== postgres8 ==== | + | |
+ | As of v5.21, ADOdb provides the: | ||
+ | * [[v5: | ||
+ | * [[v5: | ||
+ | |||
+ | ------------------------------- | ||
+ | |||
+ | ==== Example Connection Strings | ||
+ | |||
+ | <code php> | ||
+ | $db-> | ||
+ | $db-> | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== 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> | + | {{tag> |
v5/database/postgresql.1448575570.txt.gz · Last modified: 2017/04/21 11:23 (external edit)