"Brett W. McCoy" wrote:
> That's going to be database specific and not implemented via the DBD. I
> think you are better off opening a new connection to the separate
> database.
Thanks for your answer. With other words: there exists no SQL command in
PostgreSQL to switch the current selected database?
Ok, another question... ;)
Is it possible to select data from a another database than the current
selected, like many other database systems support it (e.g. Oracle,
Sybase, Informix, MySQL...), like this:
select *
from dbname.tablename
This syntax does not work with PostgreSQL:
parser: parse error at or near "."
I fear, I will not have much luck with PostgreSQL for our project...
Joern
--
Joern Reder -- Software Development, dimedis GmbH, 50672 Koeln
http://www.dimedis.de/ http://spirit.dimedis.de/
supporting: http://www.zyn.de/ http://www.netcologne.de/~nc-joernre/
CPAN: http://www.perl.com/CPAN/modules/by-module/CIPP/JRED/