SQLite Forum

How to set the column separator for the CSV extension in the CLI?
Login
I tried both options. Here's a summary.

I compiled `vsv.c` with the source of SQLite 3.32.0:

```
curl --remote-name 'http://www.dessus.com/files/vsv.c'
gcc -g -I. -fPIC -dynamiclib vsv.c -o vsv.dylib
```

got 4 warnings on compilation, still tested it with:

```
SELECT load_extension("vsv");
CREATE VIRTUAL TABLE temp.vsv USING vsv(filename="./sample.tsv");
SELECT * FROM vsv;
```

It returned an error on `CREATE VIRTUAL TABLE`:

```
Assertion failed: (sizeof(azPValue)==sizeof(azParam)), function vsvtabConnect, file vsv.c, line 946.
```

Meanwhile `.mode tabs` worked as expected:

```
.mode tabs
.import sample.tsv t1
.header on
SELECT * FROM t1;
```

Moving on with `.mode tabs`.

Thank you very much for the hints, Larry.