Re: [despammed] Reading across databases - Mailing list pgsql-novice

From Steve Tucknott
Subject Re: [despammed] Reading across databases
Date
Msg-id 1103271658.1147.17.camel@retsol1
Whole thread Raw
In response to Re: [despammed] Reading across databases  (Andreas Kretschmer <akretschmer@despammed.com>)
List 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@postgresql.org)


Regards,

Steve Tucknott

ReTSol Ltd

DDI: 01903 828769

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Reading across databases
Next
From: Michael Fuhr
Date:
Subject: Re: [despammed] Reading across databases