search

tlocke / pg8000

A Pure-Python PostgreSQL Driver
BSD 3-Clause "New" or "Revised" License
515 stars 46 forks source link

Does pg8000 support the Redshift super column type? #86

Closed blucas closed 2 years ago

blucas commented 3 years ago

To begin with, I apologize if this isn't the correct place to ask this question.

I'm trying to understand if pg8000 will correctly support extracting values from columns whose datatype is from Redshift's SUPER type.

Right now when I execute a query, the value representing the column I am interested in if of type str and I was expecting it to be a list. I am executing a query very similar to this one. In fact you can use that to test:

cursor.execute("SELECT split_to_array('12|345|6789', '|')").fetchall()

As I understand it. This should return a single row with a single column. That column should contain an array of numbers, but instead, the column is the string representation of a json array

tlocke commented 3 years ago

Hi @blucas, I'm afraid Redshift isn't officially supported by pg8000. Redshift is a fork from Postgres from about version 8 IIRC and so pg8000 may or may not work with it. So I don't know the answer to the question, but someone else might...

tlocke commented 2 years ago

I'll close this issue for now, but feel free to re-open if needed.