javascript python java c# php android html jquery c++ css ios mysql sql r node.js arrays reactjs c asp.net json ruby-on-rails .net sql-server swift python-3.x objective-c django angular angularjs excel regex pandas ruby iphone ajax linux xml vba asp.net-mvc spring laravel database wordpress typescript string wpf mongodb windows xcode postgresql bash oracle git vb.net amazon-web-services multithreading list firebase flutter eclipse spring-boot dataframe azure react-native algorithm docker macos forms image visual-studio scala powershell function twitter-bootstrap numpy api performance selenium winforms python-2.7 matlab vue.js sqlite apache hibernate entity-framework loops rest shell facebook express android-studio csv linq maven qt swing unit-testing file tensorflow

[ACCEPTED]-PHP Postgres: Get Last Insert ID-last-insert-id

Accepted answer
Score: 32

INSERT, UPDATE and DELETE in PostgreSQL 4 have a RETURNING clause which means you 3 can do:

INSERT INTO ....
RETURNING id;

Then the query will return the value 2 it inserted for id for each row inserted. Saves 1 a roundtrip to the server.

Score: 6

Yes, the sequence functions provide multiuser-safe methods for obtaining successive 1 sequence values from sequence objects.

Source: stackoverflow.com

More Related questions

Postgresql - Using subqueries with alter sequence expressions

Changing minvalue of Postgres's sequence

Doctrine2 doesn't set sequence to default for id column (postgres)

Postgres not returning lastval() properly

Get all sequences with current values

What does log_cnt mean in the postgres sequence?

Oracle Sequence nextval is jumping number back and forth

Manually forward a sequence - oracle sql

Simple Sequence Generation?

Detecting a repeating cycle in a sequence of numbers (python)