Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Can't quote_literal with COPY FROM PROGRAM
Date
Msg-id CAKFQuwYCQdJ6PDfqyYOw69KnmFXjMvZiHviXhse+o6VsvDdvmw@mail.gmail.com
Whole thread Raw
In response to Can't quote_literal with COPY FROM PROGRAM  (Mark Mikulec <mark@mikutech.com>)
List pgsql-general
Tree view
On Monday, December 31, 2018, Mark Mikulec <mark@mikutech.com> wrote:
Does anyone know how to make COPY FROM PROGRAM take the output literally?

Not that I can think of.  I’d avoid COPY FROM PROGRAM and move the logic to psql. Roughly: \set varname `cmd`; select :’varname’;

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Can't quote_literal with COPY FROM PROGRAM
Next
From: Mark Mikulec
Date:
Subject: Re: Can't quote_literal with COPY FROM PROGRAM