Skip to main content

SHOW FILE FORMATS

返回已创建的文件格式列表。

语法

SHOW FILE FORMATS;

示例

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' |
+---------------+------------------------------------------------------------------------------------------------------------------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today