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