Re: file-fdw and force_null

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Boshomi Phenix <boshomi(at)gmail(dot)com>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: file-fdw and force_null
Date: 2023-09-12 10:25:26
Message-ID: BE8F9DFE-F323-42E1-96BF-825492C3E62E@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

> On 11 Sep 2023, at 16:28, Boshomi Phenix <boshomi(at)gmail(dot)com> wrote:

> I tried to create a file-fdw foreign table with force_null for some columns.
> FORCE_NULL syntax differs from COPY. For me it was not clear that the "OPTIONS" keyword by the column was necessary, so it would be nice to add this to the example.

Considering that we don't really have the OPTIONS syntax documented in an
example, and that we reference COPY heavily on this page, I tend to agree.
How about the attached?

Looking at this it's a bit odd that we use <example> here which is very
infrequently used. It might be worth replacing this to make the docs more
uniform, but that's for another patch (and thread), for now it's using the same
syntax already present here.

--
Daniel Gustafsson

Attachment Content-Type Size
file_fdw_options.diff application/octet-stream 717 bytes

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Euler Taveira 2023-09-12 14:57:49 Re: Kernel settings shmall
Previous Message Boshomi Phenix 2023-09-11 14:28:50 file-fdw and force_null