Re: converting text to bytea

čt 25. 2. 2021 v 16:01 odesílatel Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> napsal:

> Yambu <hyambu(at)gmail(dot)com> writes:
> > Is there a reason why i'm getting text when i run the below
> > select convert_to('some_text', 'UTF8') i get back 'some_text'
>
> You must have bytea_output set to "escape".
>

yes

set bytea_output TO escape ;
postgres=# select convert_to('žlutý kůň', 'UTF8') ;
┌───────────────────────────────────────┐
│ convert_to │
╞═══════════════════════════════════════╡
│ \305\276lut\303\275 k\305\257\305\210 │
└───────────────────────────────────────┘
(1 row)

> regards, tom lane
>