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

Reading across databases

From: Steve Tucknott <steve(at)retsol(dot)co(dot)uk>
To: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Reading across databases
Date: 2004-12-17 07:48:12
Message-ID: 1103269694.1206.11.camel@retsol1 (view raw or flat)
Thread:
Lists: pgsql-novice
Postgresql 7.4.5 (pgaccess and psql) RedHat 8

Is there a way of 'cross accessing' databases?
We tend to use three environments for development - a dev_ , test_ and
rel_ prefixed database then exists - one for each environment. There are
occasions when it is very useful to be able to, say, load the test_
database with some data that has already been created in the dev_
database. I was hoping that a command such as:

INSERT INTO test_agents:someTable
    SELECT * 
         FROM dev_agents:someTable

OR simply
SELECT blah FROM databaseName:tableName.....

Is such a feature available? 


Regards,

Steve Tucknott

ReTSol Ltd

DDI: 01903 828769

Responses

pgsql-novice by date

Next:From: Andreas KretschmerDate: 2004-12-17 07:49:02
Subject: Re: [despammed] Reading across databases
Previous:From: Michael FuhrDate: 2004-12-17 06:52:09
Subject: Re: FUNCTION, TRIGGER and best practices

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