Re: Excluding a table from pg_dump

Поиск
Список
Период
Сортировка
От Ron St-Pierre
Тема Re: Excluding a table from pg_dump
Дата
Msg-id 44E1DDCD.4010201@shaw.ca
обсуждение исходный текст
Ответ на Re: Excluding a table from pg_dump  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-general
Greg Sabino Mullane wrote:
>> The database contains several schemas and excluding "comment_archive" by
>> moving it to different schema doesn't sound very convenient. pg_dump
>> doesn't have an option to dump multiple schemas at once.
>>
>> Are there any working "-X" patches for pg_dump or does anyone have other
>> possible solutions?
>>
>
> The next version of Postgres (8.2) will have the ability to do everything
> you want. It's active now in cvs, if you want to try it out. You can exclude
> one or more tables with the -T flag, and can include or exclude schemas
> with the -n and -N resepectively. Any of the four flags can be used multiple
> times, and they all accept POSIX-style regular expressions as well.
>
> - --
> Greg Sabino Mullane greg@turnstep.com
> End Point Corporation
>

That's excellent news! I've needed this feature for a while now too.

Regards

Ron St.Pierre

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

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: Connection string
Следующее
От: Pavel Velikhov
Дата:
Сообщение: Using SETOF functions in SQL