dbplyr - download postgresql jsonb data type

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?



This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.