Re: moving tables and views - Mailing list pgsql-admin

From Luis Sousa
Subject Re: moving tables and views
Date
Msg-id 3C74C235.3060205@ualg.pt
Whole thread Raw
In response to moving tables and views  (Manuel Trujillo <manueltrujillo@dorna.es>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Morten Sickel
Date:
Subject: Re: Building binary...
Next
From: "Simeone, Mario"
Date:
Subject: Why my /var/log/pgsql is empy