How to find column names of variable type record in PL/pgSQL

Language PL/pgSQL has one big disadvantage when you work with variable of type “record”. You cannot easily iterate over record columns because in this language record is not handled as “hashed” record like in JavaScript or Python etc....

Playing with JSON data in PostgreSQL

still in TODO Overview: JSON is right now very “fashionable” data format. And as they say “everyone uses it” or “it powers the whole web” etc. I remember times when XML format was “the coolest of all” and now it is...