Re: Backing up a DB excluding certain tables - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Backing up a DB excluding certain tables
Date
Msg-id b9be0698-0726-8341-00fe-696c15db9694@aklaver.com
Whole thread Raw
In response to Re: Backing up a DB excluding certain tables  (JORGE MALDONADO <jorgemal1960@gmail.com>)
Responses Re: Backing up a DB excluding certain tables
List pgsql-general
On 5/3/22 09:10, JORGE MALDONADO wrote:
> Hi,
> 
> I tried the suggestion in the "*Notes for Windows Users*" which 
> recommends the following:
> 

> 
> The first suggestion says that 1252 is the code page for German. 
> However, I used it because that is the code the DB was created with. 
> When I ran the *cmd.exe /c chcp1252* command, nothing appeared on screen 
> but it looked like something was done. So I ran the command without the 
> */c* argument so the console window remained open. Then I changed the 

If you do in a console window:

chcp
cmd.exe /c chcp 1252 --It should be this not chcp1252
chcp

You should see the value returned by chcp change from 437 to 1252 with 
the window staying open. chcp without an argument will only display the 
current code page number.

Not sure what '...so the console window remained open.' means?
Did running cmd.exe close the console window?
If so how did you get to the console(command prompt)?



> font to *Lucida Console* and ran the *pg_dump* command with different 
> combinations in the *--exclude-table* argument without success.
> 
>   * --exclude-table *.AspNet*
>   * --exclude-table '*."AspNet"*'
>   * --exclude-table '*."AspNet*"'
>   * --exclude-table'*."AspNet*"'
> 
>
------------------------------------------------------------------------------------------------------------------------------------------------------------

-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: External psql editor
Next
From: JORGE MALDONADO
Date:
Subject: Re: Backing up a DB excluding certain tables