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 @@ -6689,6 +6689,8 @@ CREATE TABLE postgres_log
6689
6689
<programlisting>
6690
6690
COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
6691
6691
</programlisting>
6692
+ It is also possible to access the file as a foreign table, using
6693
+ the supplied <xref linkend="file-fdw"/> module.
6692
6694
</para>
6693
6695
6694
6696
<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