Re: Backing up a DB excluding certain tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Backing up a DB excluding certain tables
Дата
Msg-id 22362.1651164197@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Backing up a DB excluding certain tables  (JORGE MALDONADO <jorgemal1960@gmail.com>)
Список pgsql-general
JORGE MALDONADO <jorgemal1960@gmail.com> writes:
>> *FYI, -n riopoderoso and the riopoderoso
>> in'riopoderoso."AspNetRoleClaims"' are redundant.*

> Should I remove the schema name so the exclude switch is *-T "AspNet"*
> instead of *-T 'riopoderoso."AspNet"'?*

No.  As I explained upthread, you'd better use either
    *."AspNet"*
or
    riopoderoso."AspNet"*
because otherwise the pattern won't match tables that aren't in
pg_dump's restricted search_path.

I continue to think that your problem boils down to one of getting
the quoting around the double-quoted pattern correct.  I'm not a
Windows user so I don't know much about shell quoting rules there.

            regards, tom lane



В списке pgsql-general по дате отправления:

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: Re: parallel-processing multiple similar query tasks - any example?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Privilege error with c functions during postgresql upgrade from 11 -> 13