Using Adodb for php/postgresql, return row ID after insert

Question

When I insert a row, it increments the ID field using SERIAL.

How can I return the newly created ID number right after the insert?

(Database is Postgresql.)

Answer 1

$db->Insert_ID();

Answer 2

This code works nicely:

$insertId = $adodb->getOne("INSERT INTO test (str) values ('test') RETURNING id");

Answer 3

Treat your INSERT the same as a SELECT and use RETURNING in your INSERT-query:

INSERT INTO foo (bar) VALUES('Doe') RETURNING id;

Fetch the result and you're done. Works since version 8.2