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. If anyone can I help I would appreciate it. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
