Somewhat related: how does one insert a Pandas DataFrame into a Postgres table, ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		Bishonen88 on July 10, 2019 \| parent \| context \| favorite \| on: Fast Way to Load Data into PostgreSQL Using Python Somewhat related: how does one insert a Pandas DataFrame into a Postgres table, in which most fields are merely integers being foreign keys of other tables? The DataFrame itself contains the real values (e.g. Cities, Countries etc.).

dekhn on July 10, 2019 [–]

i use write_sql but in this case you would have to resolve the object values to their integer primary keys.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact