In PHP, when using PDO with pgSQL how to get the value of "RETURNING" clause in the original INSERT sql query
insert, pdo, php, postgresql
Solution
Did you tried to treat the command as a select returning, running
$ret=$queryHandle->fetchAll();
Problem
In PHP, I am using PDO with the pgSQL drivers. I wanted to know how to get the value of the "RETURNING" clause given in the INSERT sql query. My current code looks like this, ``` $query = 'INSERT INTO "TEST" (firstname, lastname) VALUES ('John', 'Doe') RETURNING user_id'; $queryHandle = $connection->prepare($query); $queryHandle->execute(); ``` Obviously $queryHandle->execute(); returns TRUE or FALSE. But I wanted to get the value of "user_id" if the insert was successful. Can you guys give me a pointer as to how to go about it? Thanks.