Re: [ADMIN] Copying schemas between databases

2007-05-10 Thread Cédric Villemain
AIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, May 09, 2007 10:00 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Copying schemas between databases > > > > Hi > > Im using postgresql 8.2 > > I

Re: [ADMIN] Copying schemas between databases

2007-05-10 Thread Igor Neyman
Lookup "dblink" in postgres documentation. Igor From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 10:00 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Copying schemas between databases

Re: [ADMIN] Copying schemas between databases

2007-05-10 Thread Spiegelberg, Greg
See contrib/dblink. It may be able to help. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 10:00 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Copying schemas

[ADMIN] Copying schemas between databases

2007-05-10 Thread gap . mailinglists
Hi Im using postgresql 8.2 I need to access data accross databases, I believe this is not possible in Postgre. So my only alternative appears to be copying data, the whole public schema, from one database to another. For example, i have a reporting database and several other databases i would