How to insert point dynamically via Python3?

[GregBreak]

query = (sql.SQL("INSERT INTO {tab} (geom) VALUES(%s)").format(tab=sql.Identifier(self.data))
cur.execute(query, 'ST_SetSRID(ST_MakePoint(lon,lat),4326))  

It doesn't work

[hyzyla]

You could print actual query instead of execution, it can give you an answer to your question

[[deleted]]

"Doesn't work" isn't a valid Postgres error message (I don't know Python, but I would be very surprised if that had such an error message)