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

copy from json file

7 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