question

NavNig-9720 avatar image
0 Votes"
NavNig-9720 asked ·

JSON funtion and operator support in Azure Database for Postgresql

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-postgresql
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NavNig-9720, just wanted to follow up on this issue.

0 Votes 0 ·

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered ·

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?



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.