Re: [despammed] Reading across databases

From: Andreas Kretschmer <akretschmer(at)despammed(dot)com>
To: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: [despammed] Reading across databases
Date: 2004-12-17 07:49:02
Message-ID: 20041217074902.GA7578@Pinguin.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

am 17.12.2004, um 7:48:12 +0000 mailte Steve Tucknott folgendes:
> Postgresql 7.4.5 (pgaccess and psql) RedHat 8
>
> Is there a way of 'cross accessing' databases?

IMHO no. Not in a single psql-Session. But you can do this in a
client-application. There can you open any connections to several
databases.

> We tend to use three environments for development - a dev_ , test_ and
> rel_ prefixed database then exists - one for each environment. There are

You should use for this reason different schemas in one database. Then
you can cross-access between the different schemas.

Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Tel. NL Heynitz: 035242/47212
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2004-12-17 07:57:26 Re: Reading across databases
Previous Message Steve Tucknott 2004-12-17 07:48:12 Reading across databases