lidavidm opened a new issue, #2903: URL: https://github.com/apache/arrow-adbc/issues/2903
Appears to be `list[int16]`. ### Discussed in https://github.com/apache/arrow-adbc/discussions/2899 <div type='discussions-op-text'> <sup>Originally posted by **michalc** May 31, 2025</sup> I'm looking to query int2vector fields in PostgreSQL (and specifically those in pg_catalog, and specifically indoption from pg_index https://www.postgresql.org/docs/current/catalog-pg-index.html) However, if I run: ```python import adbc_driver_postgresql.dbapi with adbc_driver_postgresql.dbapi.connect("postgresql://postgres:password@127.0.0.1:5432/") as conn: with conn.cursor() as cursor: cursor.execute("SELECT indoption FROM pg_index LIMIT 1") print(cursor.fetchall()) ``` Then I get something that I'm not quite sure how to use: ``` [(b'\x00\x00\x00\x01\x00\x00\x00\x00\x00\x00\x00\x15\x00\x00\x00\x02\x00\x00\x00\x00\x00\x00\x00\x02\x00\x00\x00\x00\x00\x02\x00\x00',)] ``` Running the same query using psycopg results in ``` [('0 0',)] ``` And using psql: ``` indoption ----------- 0 0 ``` How can I get a non binary results from int2vector fields, similar to psql or psycopg? (Including maybe, how to adjust the query?) Context - I'm making a SQLAlchemy dialect for ADBC, and especially would like to support its reflection capabilities, so querying the catalogue, including its int2vector fields, is needed for this</div> -- 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: issues-unsubscr...@arrow.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
