I am reading text containing emojis from a Postgres 13 database. Turns out that my Python/psycopg query does not decode/return the text as I would expect.

Via Postgres psql client

• Within postgres:13 container

  select description from profile WHERE id = 123

Result is as expected!