$ psql
psql (9.5devel_HEAD_20140710_2144_59efda3e50ca)
Type "help" for help.

testdb=# create table t(id integer);
CREATE TABLE

testdb=# insert into t values ( 42  ) returning *;
 id
----
 42
(1 row)

INSERT 0 1