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