X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C35DBD1D174 for ; Tue, 17 Feb 2004 18:06:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 64272-08 for ; Tue, 17 Feb 2004 14:06:44 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id C888DD1CB1D for ; Tue, 17 Feb 2004 14:06:43 -0400 (AST) Received: from [63.195.55.98] (HELO 192.168.1.29) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 4444652; Tue, 17 Feb 2004 10:07:44 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Mark Gibson , PGSQL Subject: Re: Tip: a function for creating a remote view using dblink Date: Tue, 17 Feb 2004 10:05:44 -0800 User-Agent: KMail/1.5.4 References: <4030EA3D.60900@cromwell.co.uk> In-Reply-To: <4030EA3D.60900@cromwell.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200402171005.44692.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/217 X-Sequence-Number: 16907 Mark, > I'm posting a function here in the hope others may find it useful > and/or correct my mistakes/make improvements :) Thanks! Way cool! > Is there any existing site (a wiki for example) for posting PostgreSQL > specific tips? > (Wasn't sure if pgsql-sql is the right place for this kind of thing) We're working on something, but nothing's up yet. In the meantime, use the Techdocs Wiki to post it so that we don't lose track: http://techdocs.postgresql.org/guides -- -Josh Berkus Aglio Database Solutions San Francisco