Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit9de4a11

Browse files
danielgustafssonpull[bot]
authored andcommitted
doc: Add example for how to set file_fdw column option
The documentation is pretty light on how to set column optionson foreign tables, and the file_fdw docs refer to COPY whendocumenting force_null even though it's not used in the sameway. Add a small example to describe how to use it.Reported-by: Boshomi Phenix <boshomi@gmail.com>Discussion:https://postgr.es/m/CAJVkCUparn4_Oarernm=U6LWVsTkecKcALHtwGr5M3qJRj_czw@mail.gmail.com
1 parentbab1dfd commit9de4a11

File tree

1 file changed

+16
-0
lines changed

1 file changed

+16
-0
lines changed

‎doc/src/sgml/file-fdw.sgml

Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -279,4 +279,20 @@ OPTIONS ( filename 'log/pglog.csv', format 'csv' );
279279
</para>
280280
</example>
281281

282+
<example>
283+
<title>Create a Foreign Table with an option on a column</title>
284+
<para>
285+
To set the <literal>force_null</literal> option for a column, use the
286+
<literal>OPTIONS</literal> keyword.
287+
</para>
288+
<programlisting>
289+
CREATE FOREIGN TABLE films (
290+
code char(5) NOT NULL,
291+
title text NOT NULL,
292+
rating text OPTIONS (force_null 'true')
293+
) SERVER film_server
294+
OPTIONS ( filename 'films/db.csv', format 'csv' );
295+
</programlisting>
296+
</example>
297+
282298
</sect1>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp