Refer to another database

From: Andreas Kalsch <andreaskalsch(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Refer to another database
Date: 2009-08-04 02:41:51
Message-ID: 4A779FEF.4060600@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How is it possible to refer to another database, like:

select * from otherDatabase.nodes;

I have read something about schemas and I have simply created an own
schema for every database with the same name, but it still does not
work. Is there anything plain and simple?

Best,

Andi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2009-08-04 03:07:22 Re: Refer to another database
Previous Message Alvaro Herrera 2009-08-03 23:23:05 Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"