Received: from druid.net (druid.net [216.126.72.98]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0JE2V010571 for ; Fri, 19 Jan 2001 09:02:31 -0500 (EST) (envelope-from darcy@druid.net) Received: from localhost (1369 bytes) by druid.net via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp (sender: ) (ident using unix) id for ; Fri, 19 Jan 2001 09:01:33 -0500 (EST) (Smail-3.2.0.109 1999-Oct-27 #4 built 2000-Nov-20) Message-Id: From: darcy@druid.net (D'Arcy J.M. Cain) Subject: Re: Distributed database ? In-Reply-To: <946vs7$1k0v$1@news.tht.net> "from guard at Jan 18, 2001 11:00:40 pm" To: guard Date: Fri, 19 Jan 2001 09:01:33 -0500 (EST) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL78 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200101/260 X-Sequence-Number: 929 Thus spake guard > how to run "select from databaseA:tabl1 ,databaseB:table2 " You can't. You have to have two databases open and do it yourself. I use Python and often do things like this. import pg adb = pg.DB('dbase_a') bdb = pg.DB('dbase_b') row = adb.get('table_a', 1) # second argument references primary key # of table_a in database_a bdb.get('table_b', row) # one of the fields in row is the primary # key of table_b in database_b This assumes that the field names are consistent between databases otherwise you have to add an extra assignment in but that's the basic idea. Similar ways exist in other interfaces. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.