I want to get id of current inserted row after executing insertion query.
p.s.: I'm using postgresql database.
Add a comment
|
3 Answers
If we assume that by "id" you mean a column which is primary key and also is declared SERIAL then you need to add a RETURNING to the INSERT statement:
INSERT INTO <table> (...) VALUES (...) RETURNING id;
And in PHP you can treat this statement as a normal query which returns one row.
4 Comments
when this query is executed "INSERT INTO contacts (title,name,job_title,phone,email) VALUES ('tes','test s/w','0102365478','[email protected]','123') RETURNING id;" it result the error: Query failed: ERROR: syntax error at or near "RETURNING"
Milen A. Radev
Which probably means you're using older version (<8.2) of Postgres which does not support RETURNING. If possible upgrade.
Milen A. Radev
Please provide details - server version, description of the table(s) involved and the exact command sequence you tried.
In PG7 it was pg_last_oid, the docs there explain pretty clearly how to get the last id from newer version of PG.
2 Comments
when this query is executed "INSERT INTO contacts (title,name,job_title,phone,email) VALUES ('tes','test s/w','0102365478','[email protected]','123') RETURNING id;" it result the error: Query failed: ERROR: syntax error at or near "RETURNING"
RaYell
I think that should be comment to garrow's or Milen A. Radev's answers
From the Postgres documentation
Insert a single row into table distributors, returning the sequence number generated by the DEFAULT clause:
INSERT INTO distributors (did, dname) VALUES (DEFAULT, 'XYZ Widgets') RETURNING did;
http://www.postgresql.org/docs/8.3/interactive/sql-insert.html
