File tree Expand file tree Collapse file tree 2 files changed +6
-2
lines changed Expand file tree Collapse file tree 2 files changed +6
-2
lines changed Original file line number Diff line number Diff line change @@ -4899,6 +4899,8 @@ CREATE TABLE postgres_log
4899
4899
<programlisting>
4900
4900
COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
4901
4901
</programlisting>
4902
+ It is also possible to access the file as a foreign table, using
4903
+ the supplied <xref linkend="file-fdw"> module.
4902
4904
</para>
4903
4905
4904
4906
<para>
Original file line number Diff line number Diff line change 187
187
<title id="csvlog-fdw">Create a Foreign Table for PostgreSQL CSV Logs</title>
188
188
189
189
<para>
190
- One of the obvious uses for the <literal>file_fdw</> is to make
190
+ One of the obvious uses for <literal>file_fdw</> is to make
191
191
the PostgreSQL activity log available as a table for querying. To
192
- do this, first you must be logging to a CSV file, which here we
192
+ do this, first you must be <link
193
+ linkend="runtime-config-logging-csvlog">logging to a CSV file,</link>
194
+ which here we
193
195
will call <literal>pglog.csv</>. First, install <literal>file_fdw</>
194
196
as an extension:
195
197
</para>
You can’t perform that action at this time.
0 commit comments