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

Re:Show HN: Import CSV and JSON into PostgreSQL the Easy Way by jbverschoor on Tuesday August 25, 2015 @10:37AM (#10116779)

Very nice. Thanks

[ Parent | on HN ]

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/

[ Parent | on HN ]

Re:Show HN: Import CSV and JSON into PostgreSQL the Easy Way by anarazel on Tuesday August 25, 2015 @12:59PM (#10117893)

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

[ Parent | on HN ]

Re:Show HN: Import CSV and JSON into PostgreSQL the Easy Way by elchief on Tuesday August 25, 2015 @02:45PM (#10118674)

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

[ Parent | on HN ]