Python/postgres/psycopg2: getting ID of row just inserted

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

And please do not build SQL strings containing values manually. You can (and should!) pass values separately, making it unnecessary to escape and SQL injection impossible:

sql_string = "INSERT INTO domes_hundred (name,name_slug,status) VALUES (%s,%s,%s) RETURNING id;"
cursor.execute(sql_string, (hundred_name, hundred_slug, status))
hundred = cursor.fetchone()[0]

See the psycopg docs for more details: http://initd.org/psycopg/docs/usage.html#passing-parameters-to-sql-queries

More Related Contents:

  1. psycopg2: insert multiple rows with one query
  2. Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
  3. Passing table name as a parameter in psycopg2
  4. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  5. error installing psycopg2, library not found for -lssl
  6. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  7. How to set up a PostgreSQL database in Django
  8. psycopg2.OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
  9. Psycopg2 image not found
  10. Error Installing Psycopg2 on MacOS 10.9.5
  11. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  12. Create a Postgres database using python
  13. Escape SQL “LIKE” value for Postgres with psycopg2
  14. How to set connection timeout in SQLAlchemy
  15. Mac + virtualenv + pip + postgresql = Error: pg_config executable not found
  16. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  17. Psycopg2, Postgresql, Python: Fastest way to bulk-insert
  18. Insert Python Dictionary using Psycopg2
  19. Use binary COPY table FROM with psycopg2
  20. How Postgresql COPY TO STDIN With CSV do on conflic do update?
  21. How to write DataFrame to postgres table
  22. CS50: LIKE operator, variable substitution with % expansion
  23. SQLAlchemy create_all() does not create tables
  24. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  25. Can’t install psycopg2 with pip in virtualenv on Mac OS X 10.7
  26. psycopg2 installation error – Library not loaded: libssl.dylib
  27. How to upsert pandas DataFrame to PostgreSQL table?
  28. Case insensitive unique model fields in Django?
  29. python adds “E” to string
  30. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events

Leave a Comment