The ASCII Horizontal Tab is ASCII code 9.
```
insert into test (value) values ('a' || char(9) || 'b');
```
Strings consisting of characters other than 0 (which is the terminator of a C string) are inserted as-is. So you can also simply insert the data you want inserted.