Back to Clickhouse

LineAsStringWithNames

docs/en/interfaces/formats/LineAsString/LineAsStringWithNames.md

26.4.1.1-new638 B
Original Source
InputOutputAlias

Description {#description}

The LineAsStringWithNames format is similar to the LineAsString format but prints the header row with column names.

Example usage {#example-usage}

sql
CREATE TABLE example (
    name String,
    value Int32
)
ENGINE = Memory;

INSERT INTO example VALUES ('John', 30), ('Jane', 25), ('Peter', 35);

SELECT * FROM example FORMAT LineAsStringWithNames;
response
name    value
John    30
Jane    25
Peter    35

Format settings {#format-settings}