Subject: Re: insert a text file into a variable in order to insert into
 a bytea column
To: Arthur Lewis <arthur.lewis@hypermediasystems.com>,
 "David G. Johnston" <david.g.johnston@gmail.com>
References: 
 <1374628469.7191030.1454020562643.JavaMail.root@hypermediasystems.com>
Cc: pgsql-sql@postgresql.org
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <56AA9DD8.104@aklaver.com>
Date: Thu, 28 Jan 2016 15:01:44 -0800
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101
 Thunderbird/38.5.1
MIME-Version: 1.0
In-Reply-To: 
 <1374628469.7191030.1454020562643.JavaMail.root@hypermediasystems.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 01/28/2016 02:36 PM, Arthur Lewis wrote:
> Hi David,
> Yes you're correct.  The problem is caused by the back-ticks (`)  Here is what I found in the docs about back-ticks
>
> "Within an argument, text that is enclosed in backquotes (`) is taken as a command line that is passed to the shell. The output of the command (with any trailing newline removed) replaces the backquoted text."

Huh, I missed that in reading the docs.

So:

test-# \set stext `cat test.txt`
test-# \echo :stext 

Test 
 

second line 
 

test-# \set stext `cat test.txt` '\n' 

test-# \echo :stext 

Test 
 

second line 
 

test-#

New lesson learned.

>
> Arthur Lewis
>


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql