Re: Restoring a table with a different name

Поиск
Список
Период
Сортировка
От Jim Wilson
Тема Re: Restoring a table with a different name
Дата
Msg-id twig.1077929649.39531@kelcomaine.com
обсуждение исходный текст
Ответ на Restoring a table with a different name  (Mike Nolan <nolan@gw.tssi.com>)
Ответы Re: Restoring a table with a different name
Список pgsql-general
Mike Nolan said:

> I have a 600K row table on my production system (running 7.3.3)
> that I dump and load on my development system (7.4.1) every night using
> cron jobs.
>
> I would like to be able to restore the table under a different table name
> without first having to play games with the development copy of the table.
>
> If I edit the dump file with 'sed' to change the table name, I get
> 'invalid command \N' errors trying to reload it.

What sed syntax are you using?

Best,

Jim Wilson



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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Regarding BITs vs. INTs
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Regarding BITs vs. INTs