diff options
| author | Andrew Dunstan | 2023-09-30 16:34:41 +0000 |
|---|---|---|
| committer | Andrew Dunstan | 2023-09-30 16:34:41 +0000 |
| commit | f6d4c9cf162b70f2837fb6c2a83e80a3f3410695 (patch) | |
| tree | 23d62216e9b51f67ea5aff1bad95f5434b2bcd1c /src/include/commands | |
| parent | c181f2e2bcecc2704c6461a0543894a38d7143df (diff) | |
Provide FORCE_NULL * and FORCE_NOT_NULL * options for COPY FROM
These options already exist, but you need to specify a column list for
them, which can be cumbersome. We already have the possibility of all
columns for FORCE QUOTE, so this is simply extending that facility to
FORCE_NULL and FORCE_NOT_NULL.
Author: Zhang Mingli
Reviewed-By: Richard Guo, Kyatoro Horiguchi, Michael Paquier.
Discussion: https://postgr.es/m/CACJufxEnVqzOFtqhexF2+AwOKFrV8zHOY3y=p+gPK6eB14pn_w@mail.gmail.com
Diffstat (limited to 'src/include/commands')
| -rw-r--r-- | src/include/commands/copy.h | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/include/commands/copy.h b/src/include/commands/copy.h index 33175868f65..f2cca0b90b4 100644 --- a/src/include/commands/copy.h +++ b/src/include/commands/copy.h @@ -56,8 +56,10 @@ typedef struct CopyFormatOptions bool force_quote_all; /* FORCE_QUOTE *? */ bool *force_quote_flags; /* per-column CSV FQ flags */ List *force_notnull; /* list of column names */ + bool force_notnull_all; /* FORCE_NOT_NULL *? */ bool *force_notnull_flags; /* per-column CSV FNN flags */ List *force_null; /* list of column names */ + bool force_null_all; /* FORCE_NULL *? */ bool *force_null_flags; /* per-column CSV FN flags */ bool convert_selectively; /* do selective binary conversion? */ List *convert_select; /* list of column names (can be NIL) */ |