Postgresql, parse JSON

Question

I need to parse JSON objects in PL/PgSQL function and transform them in arrays, or rowsets, or whatever iterable. Is there some sort of function or plugin to do this?

Google search is clogged with JSON serialization coming in Postgresql 9.2.

Craig Ringer · Accepted Answer · 2012-09-03 13:10:49Z

2

You'll probably want to use a procedural language add-on at this point, like PL/Perl, PL/Python or PL/V8 using the language of your choice's JSON support to produce the required data.

You could probably write a C extension library to add the desired functionality, but it's unlikely to be worth the effort when it's already possible via the PLs.

I'm hoping to see (and help to add) richer JSON manipulation functions in 9.3.

answered Sep 3, 2012 at 13:10

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

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

1 Comment

Nameless Over a year ago

PL/Python it is, then. Thanks.

Collectives™ on Stack Overflow

Postgresql, parse JSON

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related