moving tables and views

Поиск
Список
Период
Сортировка
Искать

moving tables and views

От:
Manuel Trujillo <manueltrujillo@dorna.es>
Дата:
Hi.

How can I move a view from a database X to database Y??
And, when a copy one or two tables, from one database to another, whith
pg_dump, and I'm not putting the "-o" option, why preserve the oid's if
I don't want it?
Thank you very much.

-- 
Manuel Trujillo         manueltrujillo@dorna.es
Technical Engineer      http://www.motograndprix.com
Dorna Sports S.L.       +34 93 4702864

Re: moving tables and views

От:
Luis Sousa <llsousa@ualg.pt>
Дата:
Manuel Trujillo wrote:

>Hi.
>
>How can I move a view from a database X to database Y??
>And, when a copy one or two tables, from one database to another, whith
>pg_dump, and I'm not putting the "-o" option, why preserve the oid's if
>I don't want it?
>Thank you very much.
>
What I normally do is having a script, I recreate the view using that script

Luis Sousa


FAQ