Suggested enhancement to pg_restore

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Suggested enhancement to pg_restore
Дата
Msg-id CAOzAquJ48+TZLmpaCUCfE0J3ugyn_efTr+-vnWq2s5wDVhaxTQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Suggested enhancement to pg_restore
Список pgsql-general
I suggest adding the following parameter to pg_restore:

--rename-table=XXXX

When used in conjunction with the --data-only, --schema and -t options (all three of which would be necessary),
it would allow restoring a table (without indexes) to a different table name (which would need to already exist
and match the structure of the table which is being restored, of course.)

This would give PostgreSQL users the ability to reload a table from a dump file to a separate table name in the
same database and schema. 

In other words, this command:

pg_restore --data-only --schema=abc -t xyz --rename-table=xyz_copy

would restore a copy of table xyz into the existing (and presumably empty) table xyz_copy, leaving table xyz untouched.
--
Mike Nolan
nolan@tssi.com

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: heavy load-high cpu itilization
Следующее
От: Greg Smith
Дата:
Сообщение: Re: 100 times faster than mysql