(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.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
San Francisco