Re: insert a text file into a variable in order to insert into a bytea column

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Arthur Lewis <arthur(dot)lewis(at)hypermediasystems(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: insert a text file into a variable in order to insert into a bytea column
Date: 2016-01-28 21:57:38
Message-ID: CAKFQuwY8hGODYwA9eEp4dAUo3VtpVie8He4J9ZdJ22CskzJ22w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Jan 28, 2016 at 2:08 PM, Arthur Lewis <
arthur(dot)lewis(at)hypermediasystems(dot)com> wrote:

> postgres=> \set stext `cat file.txt`
> postgres=> select octet_length(:'stext');
> octet_length
> --------------
> 53603
>
> in my shell I did the following:
> $ ls -l file.txt
> -rw-rw-r-- 1 alewis alewis 53604 Jan 27 08:30 file.txt
>
> I'm still one byte short. So the problem has to be either the \set
> command chomping it or cat. I just tested cat and that seems to be working.
>
>
​Or the "back-ticks" implementation...

David J.​

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Arthur Lewis 2016-01-28 22:36:02 Re: insert a text file into a variable in order to insert into a bytea column
Previous Message Arthur Lewis 2016-01-28 21:08:18 Re: insert a text file into a variable in order to insert into a bytea column