1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
# name: test/sql/copy/csv/tsv_copy.test
# description: Test TSV Copy round-trip
# group: [csv]
statement ok
PRAGMA enable_verification
statement ok
CREATE TABLE people(id INTEGER, name VARCHAR);
statement ok
INSERT INTO people VALUES (1, 'Mark'), (2, 'Hannes');
statement ok
COPY people TO '__TEST_DIR__/test.tsv' WITH (DELIMITER '\t');
query II
SELECT * FROM '__TEST_DIR__/test.tsv'
----
1 Mark
2 Hannes
query II
SELECT * FROM read_csv('__TEST_DIR__/test.tsv', sep='\t', columns={'id': 'INTEGER', 'name': 'VARCHAR'})
----
1 Mark
2 Hannes
|
