Re: Backing up a DB excluding certain tables

On 4/26/22 12:15 PM, JORGE MALDONADO wrote:
> Hi,
> 
> I am using *pg_dump* to backup a DB but I would like to exclude some 
> tables so I added the *-T* switch with a pattern like this: *aspnet*.**. 
> The backup command  includes the *-s* switch to consider the schema only 
> because I do not need the data. However, even with the *-T* switch, the 
> tables with the above pattern are created and I also want to exclude 
> their creation. Is this possible? Or maybe I am not setting the pattern 
> correctly. This is the command I am issuing:
> 
> pg_dump -E win1252 -f c:/temp/respaldo.backup -F p -n riopoderoso -h 
> localhost -p 5432 -U postgres -W -T aspnet*.* -s riopoderoso

Try:

-T 'aspnet*.*'

Per:

https://www.postgresql.org/docs/current/app-pgdump.html

"When using wildcards, be careful to quote the pattern if needed to 
prevent the shell from expanding the wildcards; see Examples below."

And Examples is:

https://www.postgresql.org/docs/current/app-pgdump.html#PG-DUMP-EXAMPLES
> 
> Respectfully,
> Jorge Maldonado


-- 
Adrian Klaver
adrian.klaver@aklaver.com