From 7ec73783d88a743799b0c262f1235f772497fb1d Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 22 Apr 2014 16:06:37 -0400 Subject: copy: update docs for FORCE_NULL and FORCE_NOT_NULL combination Also update regression tests Patch by Michael Paquier --- doc/src/sgml/ref/copy.sgml | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 0544c68bbc0..b100f8bdf79 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -487,6 +487,13 @@ COPY count VACUUM to recover the wasted space. + + FORCE_NULL and FORCE_NOT_NULL can be used + simultaneously on the same column. This has as result to convert quoted + null strings to null values and to convert unquoted null strings to + empty strings. + + -- cgit v1.2.3