JSON funtion and operator support in Azure Database for Postgresql

NavNig 1 Reputation point
2021-02-28T03:04:06.01+00:00

Does Azure database for PostgreSQL support json function and operator? I have postgre dB installed on the VM where I am heavily using Json functions and opeartors, but, on migration of the dB to Azure database for PostgreSQL I noticed that none of my Stored procedure and functions are working in there. Is there any workaround to make them work in PaaS dB? What could be the other alternative / workaround for that? Any timelines when Json support will be rolled out in Azure database for PostgreSQL? Any url / knowledge base that can clearly point out the functionalities of On Prem PostgreSQL that are unsupported on Azure database for PostgreSQL, pls share.

I have to take some architectural decision so these points are important to know.

Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,586 Reputation points
    2021-03-01T05:59:13.197+00:00

    Hi @NavNig-9720, welcome to Microsoft Q&A forum and sorry for the trouble you have been facing.

    JSON functions are supported in Azure Database for PostgreSQL. I followed up the below article and tried multiple JSON functions and was able to run them properly in the database.

    PostgreSQL JSON

    Below is the list of functions I tried: 

    json_each()
json_object_keys()
json_typeof()

    I created the Azure PostgreSQL with version 11.

    Is it possible for you to share few functions that did not work for you, so that we can verify them by running at our end. Also which version of Azure PostgreSQL are using?

    0 comments