Pass an object(.net or json object) as input parametres of postgresql function

Question

I have just started learning postgresql, i want to send a c# object as a parameter for the function(storedprocedure) of postgresql.

i.e. assume that i have a class named userdetails with fields like username,password,DOB etc,

how can i directly send this object to the function and retrieve each field from the object before inserting into the respective columns of the desired table?

if you want to pass json to function as argument, just do it?.. — Vao Tsun
– Vao Tsun, Commented Jun 14, 2016 at 11:45
@vao tsun how do i accomplish that and insert data into respective columns of the table? an example would be great to give me a push in the right direction. — WorksOnMyLocal
– WorksOnMyLocal, Commented Jun 15, 2016 at 5:52

Vao Tsun · Accepted Answer · 2016-06-15 06:13:50Z

1

this is example of function taking json as argument:

create or replace function works_with_json(_j IN json) returns boolean as
$$
declare
begin
    raise info '%', 'a = "'||(_j->>'a')||'"';
    raise info '%', 'b = "'||(_j->>'b')||'"';
    return _j->>'c';
end;
$$ language plpgsql;

select works_with_json ('{"a":"Some string","b":9, "c": true}');

answered Jun 15, 2016 at 6:13

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

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

Collectives™ on Stack Overflow

Pass an object(.net or json object) as input parametres of postgresql function

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