Re: VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Christopher Brooks <brooksch(at)umich(dot)edu>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift
Date: 2015-08-30 19:01:58
Message-ID: 67823A2E-FE78-420A-8A07-CCFE7E02CB3F@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg


On Aug 30, 2015, at 11:59 AM, Christopher Brooks <brooksch(at)umich(dot)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(at)thebuild(dot)com

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Christopher Brooks 2015-08-30 19:04:31 Re: VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift
Previous Message Christopher Brooks 2015-08-30 18:59:13 VARCHAR versus TEXT when using psychopg2, sqlalchemy and redshift