Thank you for the information.
After testing, I found that I only need to escape the following 7 characters.
% → %25
" → %22
' → %27
+ → %2B
; → %3B
= → %3D
{ → %7B
At 2022-10-13 13:27:16, "Jeffrey Walton" <noloader@xxxxxxxxx> wrote: >On Thu, Oct 13, 2022 at 12:13 AM gzh <gzhcoder@xxxxxxx> wrote: >> >> My PostgreSQL is deployed on Amazon RDS, so the password of PostgreSQL is random and has various reserved characters. >> >> I don't know if the reserved characters below are complete, and there are some characters (e.g. * , $) I tried without problems. >> >> Could you tell me which characters require percent-encoding for PostgreSQL password? >> >> >> space → %20 >> >> ! → %21 >> >> " → %22 >> >> # → %23 >> >> $ → %24 >> >> % → %25 >> >> & → %26 >> >> ' → %27 >> >> ( → %28 >> >> ) → %29 >> >> * → %2A >> >> + → %2B >> >> , → %2C >> >> - → %2D >> >> . → %2E >> >> / → %2F >> >> : → %3A >> >> ; → %3B >> >> < → %3C >> >> = → %3D >> >> > → %3E >> >> ? → %3F >> >> @ → %40 >> >> [ → %5B >> >> \ → %5C >> >> ] → %5D >> >> ^ → %5E >> >> _ → %5F >> >> ` → %60 >> >> { → %7B >> >> | → %7C >> >> } → %7D >> >> ~ → %7E > >https://www.rfc-editor.org/rfc/rfc3986#section-2.2 > >Jeff
