Completed a set of database utilities:
- pgcopy: which uses the Postgres COPY API to import a CSV
- modifydb: which runs a database modification SQL statement
- querydb: which runs a database query
Both the “modifydb” and the “querydb” can take optional CSV inputs. See post for details and link to repo.
Enjoy!