Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

copy from json file

10 views
Skip to first unread message

sector119

unread,
Jan 15, 2019, 3:43:12 PM1/15/19
to
Hello

Is it somehow possible to COPY FROM JSON file, not CSV ?

Thanks

Benzin

unread,
Jan 18, 2019, 2:58:06 AM1/18/19
to
sector119 <sect...@gmail.com> Wrote in message:
> Hello
>
> Is it somehow possible to COPY FROM JSON file, not CSV ?
>
> Thanks
>

Yes it's possible. Here is example and tutorial how to do it

https://info.crunchydata.com/blog/fast-csv-and-json-ingestion-in
-postgresql-with-copy

Best regards
benzin
--


----Android NewsGroup Reader----
http://usenet.sinaapp.com/
0 new messages