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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "jernej-s31+pg(at)simoncic(dot)si" <jernej-s31+pg(at)simoncic(dot)si>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #18453: --exclude-database has problems with capital letters
Date: 2024-05-01 00:31:19
Message-ID: 1841675.1714523479@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Tuesday, April 30, 2024, PG Bug reporting form <noreply(at)postgresql(dot)org>
> wrote:
>> 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

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

Yeah. In a Unix shell something like
'--exclude-database="Lidar"'
would work, but I'm not up on the quoting rules under Windows.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2024-05-01 01:30:23 Re: BUG #17855: Uninitialised memory used when the name type value processed in binary mode of Memoize
Previous Message David G. Johnston 2024-05-01 00:09:29 Re: BUG #18453: --exclude-database has problems with capital letters