PostgREST / pg_csv / 31996132686

99%

push

github

add: csv_read function

The `csv_read(anyelement, text)` function can read inline text values, respecting quoting and escaping inside quotes.

```sql
select id, name
from csv_read(null::projects, E'1,IOS,4\n2,"Win""dows",4') where id = 2;
 id |   name
----+----------
  2 | Win"dows
```

This allows for greater flexibility, csv_read can be combined with
pg_read_file, inserts, limit/offset, etc.

Notes
-----

- For performance it uses SIMD parsing (via cparsec.h, which uses memchr) and avoids pallocing in
  the hot path (see `csv_slice_to_cstr`, which is a bit of a trick).
- Performance is checked by comparing to COPY CSV, this is included in
  the bench tests.

110 of 112 new or added lines in 2 files covered. (98.21%)

256 of 259 relevant lines covered (98.84%)

904.27 hits per line