Hacker News new | ask | show | jobs
Show HN: Import CSV and JSON into PostgreSQL the Easy Way (github.com)
34 points by morgenkaffee 3951 days ago
2 comments
bdcravens 3951 days ago
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
link
morgenkaffee 3951 days ago
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?

link
brunoqc 3951 days ago
"Install from source

go get github.com/lukasmartinelli/pgfutter"

link
jbverschoor 3951 days ago
Very nice. Thanks
link
morgenkaffee 3951 days ago
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/

link
anarazel 3951 days ago
> 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.

link
elchief 3951 days ago
You can use `\COPY` in PSQL remotely and without superuser privileges
link