Reading across databases - Mailing list pgsql-novice

From Steve Tucknott
Subject Reading across databases
Date
Msg-id 1103269694.1206.11.camel@retsol1
Whole thread Raw
Responses Re: [despammed] Reading across databases
Re: Reading across databases
List 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

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: FUNCTION, TRIGGER and best practices
Next
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] Reading across databases