postgres.git / summary / log / commit / refs

commit    9bb4f98bb7745b7339fb7d102cdc36d66c002f67
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Mon Aug 31 20:59:59 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 206ee4c9843..4edf75f00fc 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -7017,6 +7017,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 d985ef0a069..599952ed3d7 100644 --- a/doc/src/sgml/file-fdw.sgml +++ b/doc/src/sgml/file-fdw.sgml @@ -216,7 +216,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: 8924ca865b18]