PostgreSQL – IRZU INSTITUTE

sqldatatypes – Alternative to Postgresql BIGSERIAL data type in Azure Database?

January 1, 2022admin

I am learning Azure and data analytics with Azure. Recently finished learning Postgresql. My question is if there is an alternative to BIGSERIAL data type for Azure Databases. I ran…Read moresqldatatypes – Alternative to Postgresql BIGSERIAL data type in Azure Database?

DATA MANAGEMENT

Converting json to xml using PostgreSQL

November 25, 2021admin

i need to convert a json data to xml. the sample code is as below. from json2xml import json2xml from json2xml.utils import readfromurl, readfromstring, readfromjson data = readfromstring( ‘{“ra:covered-product-agreement”:{“login”:”mojombo”,”id”:1,”avatar_url”:”https://avatars0.githubusercontent.com/u/1?v=4″}}’ )…Read moreConverting json to xml using PostgreSQL

RESEARCH

Libpq dll c visual studio

October 7, 2021admin

Libpq dll c visual studio 07-10-2021 think, that dll studio visual libpq c opinion you are…Read moreLibpq dll c visual studio

DATA MANAGEMENT VIRTUALIZATION

Demystifying Azure Arc-enabled data services | Azure Friday

October 1, 2021admin

Lior Kamrat joins Scott Hanselman to show how Azure Arc-enabled data services bring Azure data solutions – such as SQL Managed Instance and PostgreSQL Hyperscale – to your own infrastructure…Read moreDemystifying Azure Arc-enabled data services | Azure Friday

DATA MANAGEMENT

postgresql – regex to split a string into float/number and string

September 19, 2021September 19, 2021admin

How can I split the following using regex. ‘abcd1234567ef’ into ‘abcd’, ‘1234567’, ‘ef’ ‘abcd1234567.89ef’ into ‘abcd’, ‘1234567.89’, ‘ef’ I need to split a string in Postgres SQL which may or…Read morepostgresql – regex to split a string into float/number and string