Alright, I need to seed my postgresql database from a csv. How should I approach this?

I'd start with https://www.postgresql.org/docs/current/sql-copy.html (specifically the

copy ... from stdin

style)

Here’s a tutorial which shows how to import CSV to PostgreSQL table, this might be helpful: https://www.postgresqltutorial.com/postgresql-tutorial/import-csv-file-into-posgresql-table/