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

Yes, this is what I was aiming to do. Maybe I've got the sql alchemy
syntax wrong? I though insert().values took in iterables for row by row
inserts...

Chris

On Sun, Aug 30, 2015 at 3:01 PM, Christophe Pettus <xof(at)thebuild(dot)com> wrote:

>
> 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
>
>

--
Christopher Brooks, PhD
Research Fellow

E-Mail: brooksch(at)umich(dot)edu
Web: http://www.si.umich.edu/people/christopher-brooks

Mail:School of Information
University of Michigan
4322 North Quad
105 S. State St.
Ann Arbor, MI 48109-1285