On Fri, 24 Aug 2001, uncleleo wrote:
> I am attemping to create multiple databases with Postgresql ver. 7.0.3
> running on Mandrake 8.0 rpm. The tool that I am using is Pgadmin ver 7.1.0.
>
> Can someone tell me how I can connect to different databases in a single
> select statement? Such as, I have a database named "Customer" and another
> named "Products". I wish to Select from table A in the Customer database
> and table A in Products database. I know that its possible in SQL Server and
> other databases.
You currently don't... See archives for lots of discussion of this
recently (mostly part of the mysql/pgsql thread I think).