array of bytea;

From: Tom DalPozzo <t(dot)dalpozzo(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: array of bytea;
Date: 2017-03-17 14:04:30
Message-ID: CAK77FCTAxv4KySiAK=cSJGo0A7_iQ6sU81x2nNtoFBPyt+9zMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I created a table:
CREATE TABLE MYTABLE (DATA BYTEA[]);

Now, I'd like to insert some values (a '\x0011' and a '\x2233') but I can't
find a right way.
I tried without success INSERT INTO MYTABLE VALUES ('{'\x0011','\x2233'}');
What's wrong?

Thanks
Pupillo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-03-17 14:08:16 Re: array of bytea;
Previous Message Adrian Klaver 2017-03-17 13:49:25 Re: psql - looking in wrong place for socket