From: | Steve Tucknott <steve(at)retsol(dot)co(dot)uk> |
---|---|
To: | PostGreSQL <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: [despammed] Reading across databases |
Date: | 2004-12-17 08:20:56 |
Message-ID: | 1103271658.1147.17.camel@retsol1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks Andreas, I'll take a look at using Schemas.
On Fri, 2004-12-17 at 07:49, Andreas Kretschmer wrote:
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 ===
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
Regards,
Steve Tucknott
ReTSol Ltd
DDI: 01903 828769
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2004-12-17 09:07:53 | Re: [despammed] Reading across databases |
Previous Message | Michael Fuhr | 2004-12-17 07:57:26 | Re: Reading across databases |