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

From Michael Fuhr
Subject Re: Creating table in different database
Date
Msg-id 20051024203936.GA25814@winnie.fuhr.org
Whole thread Raw
In response to Creating table in different database  (Paresh Bafna <paresh@it.iitb.ac.in>)
List pgsql-hackers
On Mon, Oct 24, 2005 at 11:32:55PM +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)?
> Is there any query to do this?

This question seems off-topic for pgsql-hackers.  The mailing list's
description says:
 The PostgreSQL developers team lives here.  Discussion of current development issues, problems and bugs, and proposed
newfeatures. If your question cannot be answered by people in the other lists, and it is likely that only a developer
willknow the answer, you may re-post your question in this list.  You must try elsewhere first!
 

You could use contrib/dblink, but perhaps you should be using schemas
instead of separate databases.

-- 
Michael Fuhr


pgsql-hackers by date:

Previous
From: Qingqing Zhou
Date:
Subject: Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance
Next
From: Simon Riggs
Date:
Subject: Re: Seeing context switch storm with 10/13 snapshot of