postgres.git / summary / log / commit / refs
commit e80e7891d35ec94659c3fe8f1d69007d7b05af42
Author: Bruce Momjian <bruce@momjian.us>
Date: Mon Aug 31 20:59:58 2020 +0000
First released in: 14.0, 9.5.24, 9.6.20, 10.15, 11.10, 12.5, 13.0
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 | 6 ++++--
2 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 15180b65096..d6439d783cf 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -5344,6 +5344,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>
[parent: 361217659dc8]