Quoting - <grandebuzon(at)gmail(dot)com>:
> I have a question about how best to insert and manipulate the table with
> primary key id for better productivity. I need to insert data into the table
> and get last id.
>
> 1. First option to take counter Postgres SEQUENCE:
> INSERT INTO table (id, ...) VALUES ((SELECT nextval ('seq_table')), ...)
> RETURNING (SELECT currval ('seq_table')) AS id
Much simplier:
INSERT INTO table (name, email, salary) VALUES ('joe', 'joe(at)example(dot)com',
100) RETURNING id;
Cheers,
-Mike
--
Michał Roszka
mike(at)if-then-else(dot)pl