Reading across databases
| От | Steve Tucknott |
|---|---|
| Тема | Reading across databases |
| Дата | |
| Msg-id | 1103269694.1206.11.camel@retsol1 обсуждение исходный текст |
| Ответы |
Re: [despammed] Reading across databases
Re: Reading across databases |
| Список | 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?
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 по дате отправления: