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 [2021/03/14 01:16] – [Using Geometry DataTypes] 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 == | ||
Line 15: | Line 23: | ||
</ | </ | ||
- | **This is the preferred driver for connections to Postgres | + | **This is the preferred driver for connections to PostgreSQL |
+ | |||
+ | <WRAP tip> | ||
+ | '' | ||
+ | </ | ||
==== Driver Specific Options ==== | ==== Driver Specific Options ==== | ||
+ | |||
None | None | ||
+ | |||
==== Using Geometry DataTypes ==== | ==== Using Geometry DataTypes ==== | ||
- | As of V5.21: | + | |
- | * ADOdb provides a constant, | + | As of v5.21, ADOdb provides the: |
- | * The [[v5: | + | * [[v5: |
+ | * [[v5: | ||
------------------------------- | ------------------------------- | ||
==== Example Connection Strings ===== | ==== Example Connection Strings ===== | ||
+ | |||
<code php> | <code php> | ||
$db-> | $db-> | ||
$db-> | $db-> | ||
</ | </ | ||
+ | |||
+ | |||
+ | ===== postgres9 ===== | ||
+ | This is the latest available driver, supporting all PostgreSQL releases since version 8. | ||
===== postgres8 ===== | ===== postgres8 ===== | ||
Line 37: | 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> | {{tag> | ||
v5/database/postgresql.1615681010.txt.gz · Last modified: 2021/03/14 01:16 by mnewnham