Re: BUG #18453: --exclude-database has problems with capital letters

On Tuesday, April 30, 2024, PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 18453
> Logged by: Jernej Simončič
> Email address: jernej-s31+pg(at)simoncic(dot)si
> PostgreSQL version: 16.2
> Operating system: Windows Server 2022
> Description:
>
> I've got a database named Lidar, which I want to exclude from being dumped
> with pg_dumpall. When I use the following command, the database is not
> skipped:
>
> "C:\Program Files\PostgreSQL\16\bin\pg_dumpall.exe"
> --exclude-database="Lidar" -U postgres > D:\dumps\pg.dump
>
> If I instead use --exclude-database="?idar", the database is skipped as
> expected (using "lidar" instead of "Lidar" also doesn't skip the database).
>
>
There is no bug here. The pattern specified doesn’t quote the identifier
so it is folded to lowercase.

https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-PATTERNS

You will need to deal with getting quotes into the pattern while dealing
with the fact your OS uses quotes for its own purpose.

David J.