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 99424D1D132 for ; Tue, 17 Feb 2004 09:11:39 +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 58838-07 for ; Tue, 17 Feb 2004 05:11:35 -0400 (AST) Received: from mail.gmx.net (imap.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 5BAF4D1B4C5 for ; Tue, 17 Feb 2004 05:11:32 -0400 (AST) Received: (qmail 3005 invoked by uid 65534); 17 Feb 2004 09:11:17 -0000 Received: from p5087E260.dip0.t-ipconnect.de (EHLO hermes.hilbert.loc) (80.135.226.96) by mail.gmx.net (mp008) with SMTP; 17 Feb 2004 10:11:17 +0100 X-Authenticated: #1433807 Received: (from ncq@localhost) by hermes.hilbert.loc (8.11.6/8.11.6/SuSE Linux 0.5) id i1H98fk01362 for pgsql-sql@postgresql.org; Tue, 17 Feb 2004 10:08:41 +0100 Date: Tue, 17 Feb 2004 10:08:41 +0100 From: Karsten Hilbert To: PGSQL Subject: Re: Tip: a function for creating a remote view using dblink Message-ID: <20040217100841.A561@hermes.hilbert.loc> References: <4030EA3D.60900@cromwell.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4030EA3D.60900@cromwell.co.uk> User-Agent: Mutt/1.3.22.1i Re-X-turn-receipt-to: Karsten.Hilbert@gmx.net Di-X-sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi-X-rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri-X-ority: 2 (High) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/206 X-Sequence-Number: 16896 > Hello, > I'm posting a function here in the hope others may find it useful > and/or correct my mistakes/make improvements :) > > This creates a view of a remote table, using dblink: ... > Is there any existing site (a wiki for example) for posting PostgreSQL > specific tips? The PG cookbook ? Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346