linqpad-postgresql-driver icon indicating copy to clipboard operation
linqpad-postgresql-driver copied to clipboard

Support columns of data type "JSON"

Open s-stoffel opened this issue 8 years ago • 0 comments

Example:

CREATE TABLE public.booking
(
  ...,
  message json NOT NULL,
  ...
)

According to the table explorer the json column is unsupported. image

The result in the data grid doesn't include the column at all. image

And of course there is no "message" property which can be selected in my LINQ statement.

It would be nice to have a rudimentary support for such columns. Treating the json values as strings, as well as the possibility to copy the (whole!) json string from the data grid would be a start. Or maybe also the C# "dynamic" could be used as "type" for the respective property, so that such properties could be used in LINQ statements.

s-stoffel avatar Sep 06 '16 09:09 s-stoffel