diff options
| -rw-r--r-- | doc/src/sgml/config.sgml | 2 | ||||
| -rw-r--r-- | doc/src/sgml/file-fdw.sgml | 6 |
2 files changed, 6 insertions, 2 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index ad4f13277fc..09f08886c63 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4899,6 +4899,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 7dd56764296..219d42431d6 100644 --- a/doc/src/sgml/file-fdw.sgml +++ b/doc/src/sgml/file-fdw.sgml @@ -187,9 +187,11 @@ <title id="csvlog-fdw">Create a Foreign Table for PostgreSQL CSV Logs</title> <para> - One of the obvious uses for the <literal>file_fdw</> is to make + One of the obvious uses for <literal>file_fdw</> 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</>. First, install <literal>file_fdw</> as an extension: </para> |