How to assign array as a variable in PostgreSQL select statement? [duplicate]

Question

I am facing problem in writing PostgreSQL select statement in Python when I have to pass more than one values in a statement. Below is the sample example.

 from sqlalchemy import create_engine

 values = [ 'a' , 'b' ]

 con = create_engine(conn_string)

 results = con.execute( "select * from table where var in (%s)", [ values ] )

I am able to run query with single value but getting format error for an array.

In the case of the duplicate, you need to change ? to %s since postgres uses different placeholders, but the principle is identical. — roganjosh
– roganjosh, Commented Oct 18, 2017 at 15:01
If you're using psycopg2 as your DB-API driver, you could pass it a tuple as the argument and it'll form a suitable form for the IN operator: initd.org/psycopg/docs/usage.html#tuples-adaptation. No need to manually create comma separated placeholders. — Ilja Everilä
– Ilja Everilä, Commented Oct 18, 2017 at 17:11

Shreyak · Accepted Answer · 2017-10-18 15:11:24Z

0

I found the answer in stackoverflow . It is a duplicate question. i was overthinking because of postgresql.

Executing “SELECT … WHERE … IN …” using MySQLdb

answered Oct 18, 2017 at 15:11

Shreyak

3363 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to assign array as a variable in PostgreSQL select statement? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related