Apologies, I am unable to create a reprex for this question.
I am trying to pull a postgresql table with a jsonb data column using dbplyr but when I do so the column in question is being pulled as a text field with a 256 character limit causing the data to be truncated.
I get this result whether I use the
dbplyr::tbl() function with
collect(tbl(con, 'table')) or directly with `dbGetQuery(con, 'select * from table').
Is there a way to specify the datatype such that the entire text is downloaded which I can then parse with jsonlite and purrr?