Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating table in different database - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Creating table in different database
Date
Msg-id 20051025154426.GA53568@winnie.fuhr.org
Whole thread Raw
In response to Creating table in different database  (Paresh Bafna <paresh@it.iitb.ac.in>)
List pgsql-general
Tree view 
On Tue, Oct 25, 2005 at 11:27:08AM +0530, Paresh Bafna wrote:
> If there are multiple databases, say db1 and db2.
> And currently we are in db1, can we create table in db2 (without
> switching databases)?

You could use contrib/dblink.  However, if you need to do this often
then it might be better to use schemas instead of separate databases.

--
Michael Fuhr

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Deleting vs foreign keys
Next
From: Claire McLister
Date:
Subject: Re: Map of Postgresql Users (OT)