How to call a function with json parameter in Postgres

Question

I have to pass a json object to a function but it's not working:

import psycopg2
cur.execute(" SELECT mrp_sp_insert_jobdef( %s )",(json(_jobdef),) )

TypeError: 'module' object is not callable

Alternatively:

cur.execute(" SELECT mrp_sp_insert_jobdef( % )",(json.dumps(_jobdef),) )

ValueError: unsupported format character ' ' (0x20) at index 31

klin · Accepted Answer · 2023-01-07 00:24:19Z

2

You can use the wrapper psycopg2.extras.Json(adapted, dumps=None), example:

import psycopg2
from psycopg2.extras import Json

conn = psycopg2.connect("dbname=test user=postgres password=password")
cur = conn.cursor()

_jobdef = {'id': 1, 'name': 'product', 'amount': 230}
cur.execute("SELECT mrp_sp_insert_jobdef( %s )", (Json(_jobdef),) )

edited Jan 7, 2023 at 0:24

answered Sep 26, 2018 at 12:41

klin

123k15 gold badges240 silver badges262 bronze badges

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

Collectives™ on Stack Overflow

How to call a function with json parameter in Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related