Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 54C2BB5DBC8 for ; Fri, 17 Jun 2011 11:51:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 90262-03 for ; Fri, 17 Jun 2011 14:51:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f46.google.com (mail-ew0-f46.google.com [209.85.215.46]) by mail.postgresql.org (Postfix) with ESMTP id 7D89DB5DBC0 for ; Fri, 17 Jun 2011 11:51:52 -0300 (ADT) Received: by ewy4 with SMTP id 4so542652ewy.19 for ; Fri, 17 Jun 2011 07:51:51 -0700 (PDT) MIME-Version: 1.0 Received: by 10.14.16.27 with SMTP id g27mr931560eeg.5.1308322311148; Fri, 17 Jun 2011 07:51:51 -0700 (PDT) Received: by 10.14.47.144 with HTTP; Fri, 17 Jun 2011 07:51:51 -0700 (PDT) In-Reply-To: <1054372046.268838.1308273696804.JavaMail.root@mail-1.01.com> References: <211773023.268832.1308273693481.JavaMail.root@mail-1.01.com> <1054372046.268838.1308273696804.JavaMail.root@mail-1.01.com> Date: Fri, 17 Jun 2011 16:51:51 +0200 Message-ID: Subject: Re: File_FDW with example From: Magnus Hagander To: Joshua Berkus Cc: pgsql-docs@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/82 X-Sequence-Number: 6856 On Fri, Jun 17, 2011 at 03:21, Joshua Berkus wrote: > (apologies for prior incomplete post. =A0Webmail spazzed on me). > > Attached is a version of file_FDW.sgml which contains a complete example = of how to use it to read your postgresql csv logs. =A0I think this does som= e neat tying together of how to use FDWs that the docs are currently lackin= g. Hey, did you steal this straight from my blog? ;) No, clearly not, because really.. Because the commands you've suggested don't work, do they? STATEMENT: CREATE FOREIGN DATA WRAPPER file_fdw HANDLER file_fdw_handler; ERROR: foreign-data wrapper "file_fdw" already exists because CREATE EXTENSION creates that one for you... --=20 =A0Magnus Hagander =A0Me: http://www.hagander.net/ =A0Work: http://www.redpill-linpro.com/