pgfutter icon indicating copy to clipboard operation
pgfutter copied to clipboard

Published 20 hours ago • verified publisher icon lukasmartinelli

support JSONL

Open twiggy opened this issue 6 years ago • 1 comments

I'm starting to see some people use JSONL and I hope it gets more traction as it solves some classic csv issues.

You support JSON import already to a "data" column in postgres, but could you also support looking at the "fields" in the first json document and then using those as if it was a csv? Wish I had time to take a stab at. :(

Great project! Thanks so much it.

twiggy avatar Jun 22 '18 16:06 twiggy

I think Postgres has powerful enough JSON support that you don't need that. You can even create indizes on JSONB fields.

lukasmartinelli avatar Jul 07 '18 10:07 lukasmartinelli