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 blah FROM databaseName:tableName.....
Is such a feature available?
DDI: 01903 828769
pgsql-novice by date
|Next:||From: Andreas Kretschmer||Date: 2004-12-17 07:49:02|
|Subject: Re: [despammed] Reading across databases|
|Previous:||From: Michael Fuhr||Date: 2004-12-17 06:52:09|
|Subject: Re: FUNCTION, TRIGGER and best practices|