Postgres getting guessed id?

Question

PostgreSQL

how to get the id of the next post? field type serial, respectively autoincrement

Answer 1

Again, these fans touch the auto-increment in the database =/

Answer 2

serial is nothing more than a combination of sequence and automatic execution of nextval on insertion.
The most convenient (in my opinion) option is to pull nextval manually before inserting and set the ID explicitly.
But in general, you can get the last value generated by the sequence, just do it after each request.

Answer 3

I know that this answer will not suit you, but if you need to know the record id before inserting, you have some problems with the architecture somewhere. Perhaps you are looking at the problem from the wrong angle. Well, at least, predicting id is an extremely dangerous undertaking, even if right now you don’t think so.