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