Re: Using psql to insert character codes - Mailing list pgsql-sql

Ian Barwick writes:

> I can do this:
> INSERT INTO my_tbl (unitxt) VALUE(encode(decode('c3a4','hex'), 'escape'))
>
> Is there any other, shorter way of doing the same?

Use octal escapes: '\303\244';

-- 
Peter Eisentraut   peter_e@gmx.net