Using python polars `read_sql` query giving error `BINARY not supported` but there are no binary type columns in my table

huangapple go评论56阅读模式
英文:

Using python polars `read_sql` query giving error `BINARY not supported` but there are no binary type columns in my table

问题

New to polars, trying to execute a simple query against a postgresql database where there are no binary type fields but I get an error RuntimeError: db error: ERROR: BINARY is not supported. I assume I am doing something wrong or I'm ignorant to how to fix. Any help is greatly appreciated.

英文:

New to polars, trying to execute a simple query against a postgresql database where there are no binary type fields but I get an error RuntimeError: db error: ERROR: BINARY is not supported. I assume I am doing something wrong or I'm ignorant to how to fix. Any help is greatly appreciated.

Using python polars `read_sql` query giving error `BINARY not supported` but there are no binary type columns in my table

答案1

得分: 1

需要将 "A closer look at the docs, and then a look at the connectorx docs, revealed that I need to set the protocol to cursor. This fixed the issue." 翻译为:「仔细查看文档,然后查看connectorx文档,发现我需要将 'protocol' 设置为 cursor。这解决了问题。」

英文:

A closer look at the docs, and then a look at the connectorx docs, revealed that I need to set the protocol to cursor. This fixed the issue.

huangapple
  • 本文由 发表于 2023年4月1日 00:36:49
  • 转载请务必保留本文链接:https://go.coder-hub.com/75900852.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定