Home/ Manual/ pgsql / functions/ pg_close

pg_close

PHP function Edit on GitHub ✎

(PHP 4, PHP 5, PHP 7, PHP 8)

Closes a PostgreSQL connection

Description

pg_close(PgSql\Connection|null $connection = null): true

pg_close() closes the non-persistent connection to a PostgreSQL database associated with the given connection instance.

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 PgSql\Lob instance on the connection, do not close the connection before closing all PgSql\Lob instances.

Parameters

connection: Connection-with-nullable-default

Return Values

Always

Changelog

Version	Description
8.0.0	`connection` is now nullable.

Examples

pg_close() example

php

<?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:

output

Connected successfully