Show HN: Import CSV and JSON into PostgreSQL the Easy Way

github.com

34 pointsmorgenkaffee7 comments

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

"Install from source

go get github.com/lukasmartinelli/pgfutter"

Sorry for the inconvenience. I moved the install from source section up in the README.

Perhaps there is a better way than providing a download from github releases and chmod+x it?

Very nice. Thanks

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/

> 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,

Nope, there's COPY ... FROM STDIN which accepts data inline, over a normal connection.

You can use `\COPY` in PSQL remotely and without superuser privileges

Reply on news.ycombinator.com