PHP: PostgreSQL Functions (PDO_PGSQL) - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

PDO_PGSQL DSN pg_version

Last updated: Fri, 26 Jan 2007

view this page in

# CXXV. PostgreSQL Functions (PDO_PGSQL)

# Введение

PDO_PGSQL is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to PostgreSQL databases.

add a note User Contributed Notes
PostgreSQL Functions (PDO_PGSQL)
amiller at php dot net
14-Jan-2007 12:12
`If you want to use "Aliasing" in your code, that is to define the DSN string in the php.ini file as described in the documentation for the constructor object for PDO itself (ex.)
try {
$dbh = new PDO("foo");
} catch(PDOException $e) {
echo $e->getMessage();
}
for the Aliasing to work, the DSN MUST be defined in the following way, following the syntax exactly... that is with double quotes, the equal sign, etc. I dinked around with this for quite some time before I figured this out. Again, that is no space between the dsn alias and the equals sign, no space after the equals sign, double quotes around the DSN, not single quotes, and spaces in between the attributes, not semicolons. I am not sure about whether you must also designate all the connection attributes show here or not but this is what ultimately worked for me.
pdo.dsn.foo="pgsql:host=localhost port=5432 dbname=foodb user=foouser password=foopassword"`
add a note
PDO_PGSQL DSN pg_version

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 11:33:19 2007 PST