pub enum CopyLegacyOption {
Show 36 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,
Credentials(String),
}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
Credentials(String)
Redshift CREDENTIALS 'auth-args'
https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-authorization.html
Trait Implementations§
Source§impl Clone for CopyLegacyOption
impl Clone for CopyLegacyOption
Source§fn clone(&self) -> CopyLegacyOption
fn clone(&self) -> CopyLegacyOption
1.0.0 (const: unstable) · 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
impl Eq 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 (const: unstable) · 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§fn eq(&self, other: &CopyLegacyOption) -> bool
fn eq(&self, other: &CopyLegacyOption) -> bool
self and other values to be equal, and is used by ==.Source§impl PartialOrd for CopyLegacyOption
impl PartialOrd for CopyLegacyOption
impl StructuralPartialEq for CopyLegacyOption
Source§impl Visit for CopyLegacyOption
impl Visit for CopyLegacyOption
Source§impl VisitMut for CopyLegacyOption
impl VisitMut for CopyLegacyOption
Source§fn visit<V>(&mut self, visitor: &mut V) -> ControlFlow<<V as VisitorMut>::Break>where
V: VisitorMut,
fn visit<V>(&mut self, visitor: &mut V) -> ControlFlow<<V as VisitorMut>::Break>where
V: VisitorMut,
VisitorMut. Read moreAuto Trait Implementations§
impl Freeze for CopyLegacyOption
impl RefUnwindSafe for CopyLegacyOption
impl Send for CopyLegacyOption
impl Sync for CopyLegacyOption
impl Unpin for CopyLegacyOption
impl UnsafeUnpin for CopyLegacyOption
impl UnwindSafe for CopyLegacyOption
Blanket Implementations§
Source§impl<Source> AccessAs for Source
impl<Source> AccessAs for Source
impl<T> Allocation for T
Source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
Source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
impl<ST, DT> CastableFrom<ST, Initialized, Initialized> for DT
impl<ST, DT> CastableFrom<ST, Uninit, Uninit> for DT
Source§impl<T> CloneToUninit for Twhere
T: Clone,
impl<T> CloneToUninit for Twhere
T: Clone,
Source§impl<Q, K> Comparable<K> for Q
impl<Q, K> Comparable<K> for Q
Source§impl<Q, K> Equivalent<K> for Q
impl<Q, K> Equivalent<K> for Q
Source§fn equivalent(&self, key: &K) -> bool
fn equivalent(&self, key: &K) -> bool
key and return true if they are equal.Source§impl<Q, K> Equivalent<K> for Q
impl<Q, K> Equivalent<K> for Q
Source§impl<Q, K> Equivalent<K> for Q
impl<Q, K> Equivalent<K> for Q
Source§impl<T> Instrument for T
impl<T> Instrument for T
Source§fn instrument(self, span: Span) -> Instrumented<Self>
fn instrument(self, span: Span) -> Instrumented<Self>
Source§fn in_current_span(self) -> Instrumented<Self>
fn in_current_span(self) -> Instrumented<Self>
Source§impl<T> IntoEither for T
impl<T> IntoEither for T
Source§fn into_either(self, into_left: bool) -> Either<Self, Self>
fn into_either(self, into_left: bool) -> Either<Self, Self>
self into a Left variant of Either<Self, Self>
if into_left is true.
Converts self into a Right variant of Either<Self, Self>
otherwise. Read moreSource§fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
self into a Left variant of Either<Self, Self>
if into_left(&self) returns true.
Converts self into a Right variant of Either<Self, Self>
otherwise. Read more