paleolimbot commented on issue #546: URL: https://github.com/apache/arrow-adbc/issues/546#issuecomment-2135890797
I just revisted this in the context of https://github.com/apache/arrow/pull/41823 and thought I'd update the reprex here with some improvements to the adbcdrivermanager R package since this happened: ``` r library(adbcdrivermanager) uri <- "postgresql://localhost:5432/postgres?user=postgres&password=password" db <- adbc_database_init(adbcpostgresql::adbcpostgresql(), uri = uri) con <- adbc_connection_init(db) con |> read_adbc("SELECT geom FROM basin_point") |> nanoarrow::infer_nanoarrow_schema() #> <nanoarrow_schema struct> #> $ format : chr "+s" #> $ name : chr "" #> $ metadata : list() #> $ flags : int 2 #> $ children :List of 1 #> ..$ geom:<nanoarrow_schema binary> #> .. ..$ format : chr "z" #> .. ..$ name : chr "geom" #> .. ..$ metadata :List of 1 #> .. .. ..$ ADBC:postgresql:typname: chr "geometry" #> .. ..$ flags : int 2 #> .. ..$ children : list() #> .. ..$ dictionary: NULL #> $ dictionary: NULL ``` <sup>Created on 2024-05-28 with [reprex v2.1.0](https://reprex.tidyverse.org)</sup> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
