Show HN: Import CSV and JSON into PostgreSQL the Easy Way (opens in new tab)

(github.com)

34 pointsmorgenkaffee10y ago7 comments

7 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

morgenkaffeeOP10y 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?

brunoqc10y ago

"Install from source

go get github.com/lukasmartinelli/pgfutter"

jbverschoor10y ago

Very nice. Thanks

morgenkaffeeOP10y 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/

anarazel10y 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.

elchief10y ago

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

j / k navigate · click thread line to collapse

7 comments

bdcravens10y 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

morgenkaffeeOP10y 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?

brunoqc10y ago

"Install from source

go get github.com/lukasmartinelli/pgfutter"

jbverschoor10y ago

Very nice. Thanks

morgenkaffeeOP10y ago

If you need a more sophisticated solution you can look at pgloader. http://pgloader.io/

anarazel10y 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.

elchief10y ago

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

j / k navigate · click thread line to collapse