Re: How to call Postgresql Array Function in Python

On Fri, Mar 9, 2012 at 12:00 PM, Rehan Saleem <pk_rehan(at)yahoo(dot)com> wrote:
> hi ,
> i am trying to call the postgresql function which takes array of type
> integer which deletes the customer record from table . which is
>
> select delcustumer('{6}')  -- where 6 is the customer id
>
> Now i am trying to call this postgresql function in python and i dont know
> how to pass array in python here is my python code
>
> i have declared a argv called custid in my python file
>
> cust =  connection.db_rel ( "select delcustumer('{}')")
> return cust
>
> how can i pass my variable custid which is an element of array which
> postgresql function is taking to this function in python .
> i shall be very thankful to you

Psycopg converts lists of python objects into arrays of the matching
type: see <http://initd.org/psycopg/docs/usage.html#adapt-list>.

You can use cur.execute("select delcustomer(%s)", ([6],)), or maybe
even cur.callproc("delcustomer", ([6],)). Note that the second
argument is a tuple with one element (the list of ids), so you need
the extra comma.

If postgres complains about not being able to find a function with the
provided arguments, try explicit casting with something like:

cur.execute("select delcustomer(%s::int[])", ([6],))

I don't know that a db_rel is.

-- Daniele