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 @@ -5870,6 +5870,8 @@ CREATE TABLE postgres_log
5870
5870
<programlisting>
5871
5871
COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5872
5872
</programlisting>
5873
+ It is also possible to access the file as a foreign table, using
5874
+ the supplied <xref linkend="file-fdw"/> module.
5873
5875
</para>
5874
5876
5875
5877
<para>
Original file line number Diff line number Diff line change 217
217
<para>
218
218
One of the obvious uses for <literal>file_fdw</literal> is to make
219
219
the PostgreSQL activity log available as a table for querying. To
220
- do this, first you must be logging to a CSV file, which here we
220
+ do this, first you must be <link
221
+ linkend="runtime-config-logging-csvlog">logging to a CSV file,</link>
222
+ which here we
221
223
will call <literal>pglog.csv</literal>. First, install <literal>file_fdw</literal>
222
224
as an extension:
223
225
</para>
You can’t perform that action at this time.
0 commit comments