Tom DalPozzo <[email protected]> writes: > I tried without success INSERT INTO MYTABLE VALUES ('{'\x0011','\x2233'}'); > What's wrong?
You've ignored the rules about how to write element values within an array literal: https://www.postgresql.org/docs/current/static/arrays.html#ARRAYS-IO Personally I tend to write an ARRAY[] construct in preference to manually adding extra quotes and backslashes to such values. regards, tom lane -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
