I changed it to be just the single float value I needed to extract out of
the JSON object, but originally it was a text column that held the entire
JSON object.
ᐧ
On Mon, Dec 31, 2018 at 3:52 PM Adrian Klaver
wrote:
> On 12/31/18 9:36 AM, Mark Mikulec wrote:
> > Hi,
> >
> >
Thanks Rob,
Since I'm on Windows and Windows batch sucks I just ended up doing the JSON
parsing with node.js
To be honest this whole affair with COPY FROM program seems like a bug to
me though.
On Mon, Dec 31, 2018 at 1:59 PM Rob Sargent wrote:
>
>
> On Dec 31, 2018, at 10:36 AM
Hi,
This command, which generates a JSON object as output, has some escaped
data with backslashes: (see line 91 here: https://pastebin.com/D4it8ybS)
C:\\Portable\\curl\\curl.exe -k "
https://maps.googleapis.com/maps/api/directions/json?etcVariablesDeleted";'
I use the COPY command to pull it int
