Re: Re: Does psqlodbc_11_01_0000-x64 support special characters?

On Thu, Oct 13, 2022 at 12:13 AM gzh <gzhcoder(at)126(dot)com> 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