(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 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
