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

Show HN: Import CSV and JSON into PostgreSQL the Easy Way(github.com)

34 points by morgenkaffee 10 years ago | 7 comments

bdcravens 10 years 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

morgenkaffee 10 years 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?

brunoqc 10 years ago | |

"Install from source

go get github.com/lukasmartinelli/pgfutter"

jbverschoor 10 years ago |

Very nice. Thanks

morgenkaffee 10 years 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/

anarazel 10 years 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.

elchief 10 years ago | | |

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