Skip to main content
Skip to main content
Edit this page

LineAsStringWithNamesAndTypes

InputOutputAlias
✗✔

Description​

The LineAsStringWithNames format is similar to the LineAsString format but prints two header rows: one with column names, the other with types.

Example Usage​

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

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

SELECT * FROM example FORMAT LineAsStringWithNamesAndTypes;
Response
name	value
String	Int32
John	30
Jane	25
Peter	35

Format Settings​