Skip site navigation (1) Skip section navigation (2)

Re: [despammed] Reading across databases

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 (view raw or flat)
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

In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2004-12-17 09:07:53
Subject: Re: [despammed] Reading across databases
Previous:From: Michael FuhrDate: 2004-12-17 07:57:26
Subject: Re: Reading across databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group