Home > mailing lists

[GENERAL] array of bytea; - Mailing list pgsql-general

From	Tom DalPozzo
Subject	[GENERAL] array of bytea;
Date	March 17, 2017 17:04:30
Msg-id	CAK77FCTAxv4KySiAK=cSJGo0A7_iQ6sU81x2nNtoFBPyt+9zMw@mail.gmail.com Whole thread Raw
Responses	Re: [GENERAL] array of bytea;
List	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

From: Steve Clark
Date: 17 March 2017, 16:58:45
Subject: Re: [GENERAL] psql - looking in wrong place for socket

From: Tom Lane
Date: 17 March 2017, 17:08:16
Subject: Re: [GENERAL] array of bytea;