📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

SHOW FILE FORMATS



Returns a list of created file formats.

Syntax

SHOW FILE FORMATS;

Examples

SHOW FILE FORMATS; +---------------+------------------------------------------------------------------------------------------------------------------------+ | name | format_options | +---------------+------------------------------------------------------------------------------------------------------------------------+ | my_custom_csv | TYPE = CSV FIELD_DELIMITER = '\t' RECORD_DELIMITER = '\n' QUOTE = '\"' ESCAPE = '' SKIP_HEADER = 0 NAN_DISPLAY = 'NaN' | +---------------+------------------------------------------------------------------------------------------------------------------------+

Was this page helpful?