Re: moving tables and views

From: Luis Sousa <llsousa(at)ualg(dot)pt>
To: Manuel Trujillo <manueltrujillo(at)dorna(dot)es>
Cc: pg-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: moving tables and views
Date: 2002-02-21 09:47:33
Message-ID: 3C74C235.3060205@ualg.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simeone, Mario 2002-02-21 10:27:55 Why my /var/log/pgsql is empy
Previous Message Manuel Trujillo 2002-02-21 09:31:18 moving tables and views