note 86178 added to pdo.lastinsertid

For PostgreSQL you can still use the old solution to return the last Id of an INSERT, selecting the currval of a table's id_sequence.

The code below shows a working function (which is easy adaptale into another class, etc).

<?php
// -------------------------
// Last Insert ID for PDO with PostgreSQL
// -------------------------
function pgsqlLastInsertId($sqlQuery, $pdoObject)
{
	// Checks if query is an insert and gets table name
	if( preg_match("/^INSERT[\t\n ]+INTO[\t\n ]+([a-z0-9\_\-]+)/is", $sqlQuery, $tablename) )
	{
		// Gets this table's last sequence value
		$query = "SELECT currval('" . $tablename[1] . "_id_seq') AS last_value";

		$temp_q_id = $pdoObject->prepare($query);
		$temp_q_id->execute();

		if($temp_q_id)
		{
			$temp_result = $temp_q_id->fetch(PDO::FETCH_ASSOC);
			return ( $temp_result ) ? $temp_result['last_value'] : false;
		}
	}

	return false;
}

?>

Example of use:

<?php
// ... connects to a PostgreSQL DB
$pdoObject = new PDO('pgsql:host=localhost;dbname=mydb', 'user', 'pass');

$sql = 'INSERT INTO table (column) VALUES (\'some_value\');';
$result = $pdoObject->prepare($sql);
$result->execute();

echo 'Last Insert ID: ' . pgsqlLastInsertId($sql, $pdoObject);

?>
----
Server IP: 200.185.109.13
Probable Submitter: 200.138.54.180
----
Manual Page -- http://www.php.net/manual/en/pdo.lastinsertid.php
Edit        -- https://master.php.net/note/edit/86178
Del: integrated  -- https://master.php.net/note/delete/86178/integrated
Del: useless     -- https://master.php.net/note/delete/86178/useless
Del: bad code    -- https://master.php.net/note/delete/86178/bad+code
Del: spam        -- https://master.php.net/note/delete/86178/spam
Del: non-english -- https://master.php.net/note/delete/86178/non-english
Del: in docs     -- https://master.php.net/note/delete/86178/in+docs
Del: other reasons-- https://master.php.net/note/delete/86178
Reject      -- https://master.php.net/note/reject/86178
Search      -- https://master.php.net/manage/user-notes.php