pg_client_encoding
pg_close(...) will not technically close a persistent connection but instead returns it back to the connection pool thus giving you the desired effect of having the connection closed within your script.
http://www.sitepoint.com/article/accessing-postgresql-php/3
best wishes to all.
pg_close
(PHP 4, PHP 5)
pg_close — Closes a PostgreSQL connection
Description
bool pg_close
([ resource
$connection
] )
pg_close() closes the non-persistent
connection to a PostgreSQL database associated with the given
connection resource.
Note:
Using pg_close() is not usually necessary, as non-persistent open connections are automatically closed at the end of the script.
If there is open large object resource on the connection, do not close the connection before closing all large object resources.
Parameters
-
connection -
PostgreSQL database connection resource. When
connectionis not present, the default connection is used. The default connection is the last connection made by pg_connect() or pg_pconnect().
Return Values
Returns TRUE on success or FALSE on failure.
Examples
Example #1 pg_close() example
<?php
$dbconn = pg_connect("host=localhost port=5432 dbname=mary")
or die("Could not connect");
echo "Connected successfully";
pg_close($dbconn);
?>
The above example will output:
Connected successfully
add a note
User Contributed Notes
pg_close - [3 notes]
amays ¶
7 years ago
mark at redbrick dot dcu dot ie ¶
10 years ago
This function closes the current database connection specified by a handle returned from a pg_connect() call.
<?php
$pgsql_conn = pg_connect("dbname=mark host=localhost");
if ($pgsql_conn) {
print "Successfully connected to: " . pg_host($pgsql_conn) . "<br/>\n";
} else {
print pg_last_error($pgsql_conn);
exit;
}
// Do database stuff here.
if(!pg_close($pgsql_conn)) {
print "Failed to close connection to " . pg_host($pgsql_conn) . ": " .
pg_last_error($pgsql_conn) . "<br/>\n";
} else {
print "Successfully disconnected from database";
}
?>
Of course you normally wouldn't print a message.
Regards, --mark
nox at macports dot org ¶
5 years ago
An E_WARNING level warning is generated if the supplied argument is not a valid postgresql link resource.