pub enum CopyLegacyOption {
Show 35 variants
AcceptAnyDate,
AcceptInvChars(Option<String>),
AddQuotes,
AllowOverwrite,
Binary,
BlankAsNull,
Bzip2,
CleanPath,
CompUpdate {
preset: bool,
enabled: Option<bool>,
},
Csv(Vec<CopyLegacyCsvOption>),
DateFormat(Option<String>),
Delimiter(char),
EmptyAsNull,
Encrypted {
auto: bool,
},
Escape,
Extension(String),
FixedWidth(String),
Gzip,
Header,
IamRole(IamRoleKind),
IgnoreHeader(u64),
Json(Option<String>),
Manifest {
verbose: bool,
},
MaxFileSize(FileSize),
Null(String),
Parallel(Option<bool>),
Parquet,
PartitionBy(UnloadPartitionBy),
Region(String),
RemoveQuotes,
RowGroupSize(FileSize),
StatUpdate(Option<bool>),
TimeFormat(Option<String>),
TruncateColumns,
Zstd,
}Expand description
An option in COPY statement before PostgreSQL version 9.0.
Variants§
AcceptAnyDate
ACCEPTANYDATE
AcceptInvChars(Option<String>)
ACCEPTINVCHARS
AddQuotes
ADDQUOTES
AllowOverwrite
ALLOWOVERWRITE
Binary
BINARY
BlankAsNull
BLANKSASNULL
Bzip2
BZIP2
CleanPath
CLEANPATH
CompUpdate
COMPUPDATE [ PRESET | { ON | TRUE } | { OFF | FALSE } ]
Fields
Csv(Vec<CopyLegacyCsvOption>)
CSV …
DateFormat(Option<String>)
DATEFORMAT [ AS ] {‘dateformat_string’ | ‘auto’ }
Delimiter(char)
DELIMITER [ AS ] ‘delimiter_character’
EmptyAsNull
EMPTYASNULL
Encrypted
ENCRYPTED \[ AUTO \]
Escape
ESCAPE
Extension(String)
EXTENSION ‘extension-name’
FixedWidth(String)
FIXEDWIDTH [ AS ] ‘fixedwidth-spec’
Gzip
GZIP
Header
HEADER
IamRole(IamRoleKind)
IAM_ROLE { DEFAULT | ‘arn:aws:iam::123456789:role/role1’ }
IgnoreHeader(u64)
IGNOREHEADER [ AS ] number_rows
Json(Option<String>)
JSON [ AS ] ‘json_option’
Manifest
MANIFEST [ VERBOSE ]
MaxFileSize(FileSize)
MAXFILESIZE [ AS ] max-size [ MB | GB ]
Null(String)
NULL \[ AS \] 'null_string'
Parallel(Option<bool>)
PARALLEL [ { ON | TRUE } | { OFF | FALSE } ]
Parquet
PARQUET
PartitionBy(UnloadPartitionBy)
PARTITION BY ( column_name [, … ] ) [ INCLUDE ]
Region(String)
REGION [ AS ] ‘aws-region’ }
RemoveQuotes
REMOVEQUOTES
RowGroupSize(FileSize)
ROWGROUPSIZE [ AS ] size [ MB | GB ]
StatUpdate(Option<bool>)
STATUPDATE [ { ON | TRUE } | { OFF | FALSE } ]
TimeFormat(Option<String>)
TIMEFORMAT [ AS ] {‘timeformat_string’ | ‘auto’ | ‘epochsecs’ | ‘epochmillisecs’ }
TruncateColumns
TRUNCATECOLUMNS
Zstd
ZSTD
Trait Implementations§
Source§impl Clone for CopyLegacyOption
impl Clone for CopyLegacyOption
Source§fn clone(&self) -> CopyLegacyOption
fn clone(&self) -> CopyLegacyOption
1.0.0 · Source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
source. Read moreSource§impl Debug for CopyLegacyOption
impl Debug for CopyLegacyOption
Source§impl Display for CopyLegacyOption
impl Display for CopyLegacyOption
Source§impl Hash for CopyLegacyOption
impl Hash for CopyLegacyOption
Source§impl Ord for CopyLegacyOption
impl Ord for CopyLegacyOption
Source§fn cmp(&self, other: &CopyLegacyOption) -> Ordering
fn cmp(&self, other: &CopyLegacyOption) -> Ordering
1.21.0 · Source§fn max(self, other: Self) -> Selfwhere
Self: Sized,
fn max(self, other: Self) -> Selfwhere
Self: Sized,
Source§impl PartialEq for CopyLegacyOption
impl PartialEq for CopyLegacyOption
Source§impl PartialOrd for CopyLegacyOption
impl PartialOrd for CopyLegacyOption
Source§impl Visit for CopyLegacyOption
impl Visit for CopyLegacyOption
Source§impl VisitMut for CopyLegacyOption
impl VisitMut for CopyLegacyOption
Source§fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>
fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>
VisitorMut. Read more