Mysql last_insert_id() to postgres

[axman505]

I am trying to figure out an equivalant function in postgresql for mysql last_insert_id .. i have seen curval() should do it, but i am relatively new to postgresql and having some problems. Can anyone offer any pointers? Thanks.

 

[ceco]

well curval is what you need if the id field is of type serial then find the sequence name (usually tableName_fieldName_seq)

and do SELECT currval('tableName_fieldName_seq');

this should be done after insert-ing in the table