File tree Expand file tree Collapse file tree 2 files changed +5
-1
lines changed Expand file tree Collapse file tree 2 files changed +5
-1
lines changed Original file line number Diff line number Diff line change @@ -7017,6 +7017,8 @@ CREATE TABLE postgres_log
7017
7017
<programlisting>
7018
7018
COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
7019
7019
</programlisting>
7020
+ It is also possible to access the file as a foreign table, using
7021
+ the supplied <xref linkend="file-fdw"/> module.
7020
7022
</para>
7021
7023
7022
7024
<para>
Original file line number Diff line number Diff line change 216
216
<para>
217
217
One of the obvious uses for <literal>file_fdw</literal> is to make
218
218
the PostgreSQL activity log available as a table for querying. To
219
- do this, first you must be logging to a CSV file, which here we
219
+ do this, first you must be <link
220
+ linkend="runtime-config-logging-csvlog">logging to a CSV file,</link>
221
+ which here we
220
222
will call <literal>pglog.csv</literal>. First, install <literal>file_fdw</literal>
221
223
as an extension:
222
224
</para>
You can’t perform that action at this time.
0 commit comments