Re: VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift - Mailing list psycopg

From Christophe Pettus
Subject Re: VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift
Date
Msg-id 67823A2E-FE78-420A-8A07-CCFE7E02CB3F@thebuild.com
Whole thread Raw
In response to VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift  (Christopher Brooks <brooksch@umich.edu>)
Responses Re: VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift
List psycopg
On Aug 30, 2015, at 11:59 AM, Christopher Brooks <brooksch@umich.edu> wrote:
>  [SQL: 'INSERT INTO qualtrics_dim (k, v) VALUES (%(k)s, %(v)s)'] [parameters: {'v': ['aa', 'bb'], 'k': ['a', 'b']}]

The values you've written there are two arrays of TEXT values, but the columns aren't declared as TEXT or VARCHAR
arrays,but as single VARCHAR values.  Are you trying to insert two rows of the form 'aa', 'a' and 'bb', 'b'? 

--
-- Christophe Pettus
   xof@thebuild.com



psycopg by date:

Previous
From: Christopher Brooks
Date:
Subject: VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift
Next
From: Christopher Brooks
Date:
Subject: Re: VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift