Skip site navigation (1) Skip section navigation (2)

moving tables and views

From: Manuel Trujillo <manueltrujillo(at)dorna(dot)es>
To: pg-admin <pgsql-admin(at)postgresql(dot)org>
Subject: moving tables and views
Date: 2002-02-21 09:31:18
Message-ID: 1014283878.800.25.camel@klingon (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)dorna(dot)es
Technical Engineer      http://www.motograndprix.com
Dorna Sports S.L.       +34 93 4702864


Responses

pgsql-admin by date

Next:From: Luis SousaDate: 2002-02-21 09:47:33
Subject: Re: moving tables and views
Previous:From: Morten SickelDate: 2002-02-21 09:28:07
Subject: Re: Building binary...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group