Received: from cvis29.marconicomms.com (cvis29.marconicomms.com [195.99.244.61]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9UFsZC34349 for ; Mon, 30 Oct 2000 10:54:35 -0500 (EST) (envelope-from Carl.Shelbourne@marconi.com) Received: from cvis01.gpt.co.uk (unverified) by cvis29.marconicomms.com (Content Technologies SMTPRS 4.1.5) with ESMTP id for ; Mon, 30 Oct 2000 13:18:14 +0000 Received: from marconicomms.com by cvis01.gpt.co.uk with SMTP (8.8.8+Sun/cvms-28) id NAA10433; Mon, 30 Oct 2000 13:18:07 GMT Received: by marconicomms.com(Lotus SMTP MTA v4.6.3 (733.2 10-16-1998)) id 80256988.00490EFB ; Mon, 30 Oct 2000 13:17:59 +0000 X-Lotus-FromDomain: MCMAIN@MCEXT From: "Carl Shelbourne" To: pgsql-sql@postgresql.org Message-ID: <80256988.00490BAB.00@marconicomms.com> Date: Mon, 30 Oct 2000 13:17:24 +0000 Subject: Synonyms Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Disposition: inline X-Archive-Number: 200010/13 X-Sequence-Number: 13 HELP!!! * Is there a way of creating synonyms of tables within one database in another database in Postgres similar to the Informix CREATE SYNONYM? * If not and related to the post on 2000-10-28 by Sivagami, is there a way, within a select I can make a query from mulitple databases. ( the usual DB.Table or DB:table or DB@table dont seem to work) Thanks Carl