import psycopg2.extras

# call it in any place of your program

# before working with UUID objects in PostgreSQL

psycopg2.extras.register_uuid()

# now you can pass UUID objects into psycopg2 functions

cursor.execute("INSERT INTO MyTable (uuid) VALUES (%s)", (uuid.uuid4(),))

# ... and even get it from there

cursor.execute("SELECT uuid FROM MyTable")

value, = cursor.fetchone()

assert isinstance(value, uuid.UUID)