The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/runtime-config-logging.html Description:
There is some imperfection in PostgreSQL doc. There are two section in documentation how to import PostgreSQL log into sql space and both not complete. One of them is: https://www.postgresql.org/docs/current/file-fdw.html Example F.1. Create a Foreign Table for PostgreSQL CSV Logs Here is described how to config file-fdw to get access to the PostgreSQL logs, but there is not description or a link how to config PostgreSQL log for this. Other section is: https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG 19.8.4. Using CSV-Format Log Output Here is described how to configure PostgreSQL log to import it into previously created ordinary table by COPY command. May be this configuration is compatible with "Example F.1. Create a Foreign Table for PostgreSQL CSV Logs", but this method is not mentioned. My idea to improve documentation by adding cross link: to section «Example F.1. Create a Foreign Table for PostgreSQL CSV Logs» add link to «19.8.4. Using CSV-Format Log Output» as example of log configuration and to section «19.8.4. Using CSV-Format Log Output» add link to «Example F.1. Create a Foreign Table for PostgreSQL CSV Logs» as one more example how PostgreSQL logs can be imported inside PostgreSQL.
