diff --git a/doc/src/sgml/file-fdw.sgml b/doc/src/sgml/file-fdw.sgml index 56d696c323..72b45bf8d3 100644 --- a/doc/src/sgml/file-fdw.sgml +++ b/doc/src/sgml/file-fdw.sgml @@ -279,4 +279,20 @@ OPTIONS ( filename 'log/pglog.csv', format 'csv' ); + + Foreign table with option + + To set the force_null option for a column, use the + OPTIONS keyword. + + +CREATE FOREIGN TABLE films ( + code char(5) NOT NULL, + title text NOT NULL, + rating text OPTIONS (force_null 'true') +) SERVER film_server +OPTIONS ( filename 'films/db.csv', format 'csv' ); + + +