How to get a value from the last inserted row? [duplicate]

With PostgreSQL you can do it via the RETURNING keyword:

PostgresSQL – RETURNING

INSERT INTO mytable( field_1, field_2,... )
VALUES ( value_1, value_2 ) RETURNING anyfield

It will return the value of “anyfield”. “anyfield” may be a sequence or not.

To use it with JDBC, do:

ResultSet rs = statement.executeQuery("INSERT ... RETURNING ID");
rs.next();
rs.getInt(1);