DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=uH5xwMsygR8vZF0k0ieBaNXPbEWaRWEzRXAzjYSMfoluvxpB0wGQDvv0m+QtsTb5X6
	Fp8W+1u3ZGkUyaVITCTAzBWUI9SnkdKFLVXnL2S4Co8ByosXf1BYHjrT1Ogr+dyIT7xj
	2swirxFY4SCaw9WniF2XluMQmiyUkmsmGJC/w=
Message-ID: <4DFB36D7.3070208@gmail.com>
Date: Fri, 17 Jun 2011 20:13:27 +0900
From: Shigeru Hanada <shigeru.hanada@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja;
	rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
MIME-Version: 1.0
To: Joshua Berkus <josh@agliodbs.com>
CC: pgsql-docs@postgresql.org
Subject: Re: File_FDW with example
References: <1054372046.268838.1308273696804.JavaMail.root@mail-1.01.com>
In-Reply-To: <1054372046.268838.1308273696804.JavaMail.root@mail-1.01.com>
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit

(2011/06/17 10:21), Joshua Berkus wrote:
> (apologies for prior incomplete post.  Webmail 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.  I think this does some neat tying together of how to use FDWs that the docs are currently lacking.

Such example would be useful for administrators who wants to manage
servers via SQL. :-)

I examined the example, and found some points which should be corrected:

- Some lines are over 80 columns.
- CREATE EXTENSION file_fdw also creates default FOREIGN DATA WRAPPER
file_fdw, so no need to create FOREIGN DATA WRAPPER explicitly.

BTW, filename option can be changed via SQL:

ALTER FOREIGN TABLE pglog OPTIONS ( SET filename '/path/to/new/file' );

I think it's worth to mention the way to switch to new log file after
log rotation.

Regards,
-- 
Shigeru Hanada