postgres.git / summary / log / commit / refs

commit    5e22362d3199a0946f4e5204f8185370fcc2bded
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Mon Aug 31 20:59:58 2020 +0000

    doc: cross-link file-fdw and CSV config log sections
    
    There is an file-fdw example that reads the server config file, so cross
    link them.
    
    Reported-by: Oleg Samoilov
    
    Discussion: https://postgr.es/m/159800192078.2886.10431506404995508950@wrigleys.postgresql.org
    
    Backpatch-through: 9.5


doc/src/sgml/config.sgml | 2 ++ doc/src/sgml/file-fdw.sgml | 4 +++- 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 2227ae33c8f..19abd7fe65d 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -5870,6 +5870,8 @@ CREATE TABLE postgres_log <programlisting> COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; </programlisting> + It is also possible to access the file as a foreign table, using + the supplied <xref linkend="file-fdw"/> module. </para> <para> diff --git a/doc/src/sgml/file-fdw.sgml b/doc/src/sgml/file-fdw.sgml index 7944f0d4a76..87f2703f0a7 100644 --- a/doc/src/sgml/file-fdw.sgml +++ b/doc/src/sgml/file-fdw.sgml @@ -217,7 +217,9 @@ <para> One of the obvious uses for <literal>file_fdw</literal> is to make the PostgreSQL activity log available as a table for querying. To - do this, first you must be logging to a CSV file, which here we + do this, first you must be <link + linkend="runtime-config-logging-csvlog">logging to a CSV file,</link> + which here we will call <literal>pglog.csv</literal>. First, install <literal>file_fdw</literal> as an extension: </para> [parent: bdfd83f4a4cf]