"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/

Reply via email to