Thread: moving tables and views

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

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