4 ms·
This is great news. As someone working on GOV.UK projects and regularly working with large, unwieldy CSVs I can't recommend CSVKit[0] highly enough. Being able
by petepete 7y ago
This is great news.
As someone working on GOV.UK projects and regularly working with large, unwieldy CSVs I can't recommend CSVKit[0] highly enough. Being able to go from CSV to PostgreSQL in one or two simple steps is _priceless_ for me.
[0] https://csvkit.readthedocs.io/en/latest/ https://csvkit.readthedocs.io/en/latest/
- jimsmart 7y agoI've had good success using Postgres' built-in CSV import/export command (COPY) in the past — depends on one's workflow, obviously! https://www.postgresql.org/docs/12/sql-copy.html https://www.postgresql.org/docs/12/sql-copy.html