Received: from mail.greatgulfhomes.com (www.greatgulfhomes.com
	[216.94.125.243])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f92GaGn02638
	for <pgsql-docs@postgresql.org>; Tue, 2 Oct 2001 12:36:16 -0400 (EDT)
	(envelope-from terry@greatgulfhomes.com)
Received: from terrynew2 (firewall.development.greatgulfhomes.com
	[216.191.203.106])
	by mail.greatgulfhomes.com (8.11.3/8.11.3) with SMTP id f92Gfle18751
	for <pgsql-docs@postgresql.org>; Tue, 2 Oct 2001 12:41:47 -0400
From: terry@greatgulfhomes.com
To: "Postgres (E-mail)" <pgsql-docs@postgresql.org>
Subject: Table view from another database
Date: Tue, 2 Oct 2001 12:36:19 -0400
Message-ID: <000c01c14b60$5df0f2a0$2766f30a@development.greatgulfhomes.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Archive-Number: 200110/14
X-Sequence-Number: 1028

Is there a way to create a view (or mirror or something) of a table in my
current database when the table actually resides in a different database
(it's on the same server, running under the same postmaster if that helps at
all).

thanks

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry@greatgulfhomes.com