How do I get the “id” after INSERT into a postgres database with Python?

Question

I am doing an INSERT into a postgres DB, which has an auto increment field called id.

How do I get the value of id after doing the insert in Python? There are good references on this site to this for MySQL databases (i.e. using cursor.lastrowid, or connection.insert_id()) but these don't seem to work with my postgres DB.

The id field is using a sequence to auto increment. So the id field is not null, default, nextval('table_id_seq')

Thanks

Please also mention the library you are to make connection with postgres. Is it PyODBC? — Moinuddin Quadri
– Moinuddin Quadri, Commented Nov 23, 2016 at 11:41
Possible duplicate of postgreSQL function for last inserted ID — fredtantini
– fredtantini, Commented Nov 23, 2016 at 11:41

user1208486 · Accepted Answer · 2018-09-20 09:19:17Z

4

Pls try that:

cursor.execute("INSERT INTO .... RETURNING
id_of_new_row = cursor.fetchone()[0]

edited Sep 20, 2018 at 9:19

answered Sep 20, 2018 at 9:13

user1208486

413 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Evandro Coan Over a year ago

It should be cursor.execute("INSERT INTO .... RETURNING primary_key_field_name;

Collectives™ on Stack Overflow

How do I get the “id” after INSERT into a postgres database with Python?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related