From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
Cc: | " \"Stéphane Schildknecht" <stephane(dot)schildknecht(at)postgresqlfr(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Excluding schema from backup |
Date: | 2006-12-08 15:21:30 |
Message-ID: | 5096.1165591290@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bill Moran <wmoran(at)collaborativefusion(dot)com> writes:
> In response to "Stphane Schildknecht" <stephane(dot)schildknecht(at)postgresqlfr(dot)org>:
>> pg_dump -U postgres MYDB -N "_MYDB" gives me a dump including that schema.
>>
>> I then tried pg_dump -U postgres MYDB -n "_MYDB" and then got "pg_dump:
>> No matching schemas were found"
> My guess is that you're hitting case-folding issues. Try:
> pg_dump -U postgres MYDB -n \"_MYDB\"
Yeah, see the last example in the 8.2 pg_dump reference page:
To specify an upper-case or mixed-case name in -t and related
switches, you need to double-quote the name; else it will be folded to
lower case (see Patterns). But double quotes are special to the shell,
so in turn they must be quoted. Thus, to dump a single table with a
mixed-case name, you need something like
$ pg_dump -t '"MixedCaseName"' mydb > mytab.sql
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2006-12-08 15:23:11 | Male/female |
Previous Message | Marc Evans | 2006-12-08 15:16:34 | creating functions with variable argument lists |