Re:Show HN: Import CSV and JSON into PostgreSQL the Easy Way
by bdcravens on Tuesday August 25, 2015 @05:10PM
(#10119472)
As someone kinda ok with go, I'm a little concerned that there's no info on building a binary, and all of the instructions in the README say to download their binary and chmod +x it
Re:Show HN: Import CSV and JSON into PostgreSQL the Easy Way
by morgenkaffee on Tuesday August 25, 2015 @11:30AM
(#10117153)
I know you can already do that with the `COPY FROM` statement in Postgres but I always think it is a pain because you need physical access, need the files to be 100% correct and you have no progress indication.
If you need a more sophisticated solution you can look at pgloader. http://pgloader.io/
Perhaps there is a better way than providing a download from github releases and chmod+x it?
go get github.com/lukasmartinelli/pgfutter"
If you need a more sophisticated solution you can look at pgloader. http://pgloader.io/
Nope, there's COPY ... FROM STDIN which accepts data inline, over a normal connection.