Postgres Pro
Downloads
Home   >   mailing lists

Can't quote_literal with COPY FROM PROGRAM - Mailing list pgsql-general

From Mark Mikulec
Subject Can't quote_literal with COPY FROM PROGRAM
Date
Msg-id CA+aX0efk8+9WAHGsC8vtiuxPsZPik=aUUHrPXyp5L7Kq9HNLHA@mail.gmail.com
Whole thread Raw
Responses Re: Can't quote_literal with COPY FROM PROGRAM  (Rob Sargent <robjsargent@gmail.com>)
Re: Can't quote_literal with COPY FROM PROGRAM  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Can't quote_literal with COPY FROM PROGRAM  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
Hi,

This command, which generates a JSON object as output, has some escaped data with backslashes: (see line 91 here: https://pastebin.com/D4it8ybS)


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"';

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
ᐧ

pgsql-general by date:

Previous
From: Chuck Martin
Date:
Subject: Re: getting pg_basebackup to use remote destination
Next
From: Rob Sargent
Date:
Subject: Re: Can't quote_literal with COPY FROM PROGRAM