when connecting to redshift using pgcli, this error might happen:

codec not available in Python: 'UNICODE'

this can be fixed by setting environment variable:

PGCLIENTENCODING=utf-8

• By saml.
• On 08 Apr 2026.