Re: Can't quote_literal with COPY FROM PROGRAM

On 12/31/18 9:36 AM, Mark Mikulec wrote:
> 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 into a temp table like so:
> 
> COPY temp_maps_api from program 'C:\\Portable\\curl\\curl.exe -k 
> "https://maps.googleapis.com/maps/api/directions/json?etcVariablesDeleted"';

So temp_maps_api has a single JSON field?

> 
> However copy eats those backslashes. I need to use quote_literal() but 
> that's a syntax error. For some reason the COPY command doesn't allow 
> for ESCAPE to work with programs, only CSV.
> 
> I tried using WITH BINARY but I get the error message: "COPY file 
> signature not recognized"
> 
> Does anyone know how to make COPY FROM PROGRAM take the output literally?
> 
> Thanks,
>    Mark
> ᐧ


-- 
Adrian Klaver
adrian.klaver@aklaver.com