How to insert a timestamp without timezone into postgres using Python

python-postgres-insert-eopch-timestamp-without-timezone.md

HOWTO: Insert a timestamp without timezone into postgres using Python

Background

I searched the net high and low but was unable to locate a definitive working example of how to take an epoch integer timestamp and insert it as a native postgres timestamp without timezone.

CREATE TABLE IF NOT EXISTS tz_test (
    stamp TIMESTAMP NOT NULL
);

import time
import psycopg2

# ... snip ...

epoch = 1637599938

stamp = time.strftime("%Y-%m-%d %H:%M:%S", datetime.datetime.utcfromtimestamp(stamp).timetuple()),

cursor.execute('''INSERT INTO tz_test (stamp) VALUES (%s)''', stamp)