Re: proposal: psql \setfileref - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal: psql \setfileref
Date
Msg-id CAFj8pRDFyhx+HuecaBqnBsW9iZGyDodxUVw1A4RG0BdX79gRvg@mail.gmail.com
Whole thread Raw
In response to Re: proposal: psql \setfileref  (Corey Huinker <corey.huinker@gmail.com>)
List pgsql-hackers


2016-11-15 16:41 GMT+01:00 Corey Huinker <corey.huinker@gmail.com>:

On Sun, Nov 13, 2016 at 1:46 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
r - read file without any modification
rq - read file, escape as literal and use outer quotes
rb - read binary file - transform to hex code string
rbq - read binary file, transform to hex code string and use outer quotes

Usage:

I am not asking for this feature now, but do you see any barriers to later adding x/xq/xb/xbq equivalents for executing a shell command?

any other new commands can be appended simply - this is really generic

Regards

Pavel

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Parallel tuplesort (for parallel B-Tree index creation)
Next
From: Tom Lane
Date:
Subject: Re: postgres_fdw and defaults