How to get a "€" (u+20AC) character in a postgres UTF8 client encoding?

Question

I only found some strange results online where somebody tried select E'\x020AC', select E'\x020\x0AC' or select E'\x0AC\x020' but none worked.

Answer 1

So I had to search and read more carefully in the pg docs and found the solution:

select U&'\20AC'  -- => "€"
select E'\u20AC'  -- => "€"