python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - postgresql

PostgreSQL aggregate over json arrays

I have seen a lot of references to using json_array_elements on extracting the elements of a JSON array. However, this appears to only work on exactly 1 array. If I use this in a generic query, I get ...
test-img

Aserian

arrays

json

postgresql

aggregate-functions

jsonb

Votes: 0

Answers: 1

Latest Answer

Use the function for orders->'items' to flatten the data: select elem->>'name' as name, (elem->>'price')::numeric as price from my_table cross join jsonb_array_elements(orders->'item...
test-img

klin

80 Postgres databases in Azure Data Factory to copy into

I'm using Azure Data factory, I'm using SQLServer as source and Postgres as target. Goal is to copy 30 tables from SQLServer, with transformation, to 30 tables in Postgres. Hard part is I have 80 data...
test-img

BobL

sql-server

postgresql

azure-data-factory

parameterization

Votes: 0

Answers: 1

Latest Answer

There is simple way to implement this. Essentially you need to have a single Linked Service, which reads the connection string out of KeyVault. You can then parameterize source and target as keyvault ...
test-img

Cninroh

Quarkus reactive postgres client IAM authentication token refresh

I am using Quarkus 2.5.1.Final to build one microservice. I am using hibernate reactive with postgres as database. At my organization we use AWS IAM auth tokens for database authentication. AWS IAM t...
test-img

DGS

postgresql

amazon-iam

quarkus

reactive

Votes: 0

Answers: 0

Adding a column with a static value in PostgreSQL

It's a very basic question but I'm still confused. I need to add a column(country_code) to store the country's ISO code ('CYP') as a static value in a Table (TableA) What would be the best way to do i...
test-img

Shaurya

sql

postgresql

Votes: 0

Answers: 1

Latest Answer

Put a check constraint on it that checks if it's 'CYP'. ALTER TABLE tablea ADD country_code varchar(3) NOT NULL DEFAULT 'CYP'; ALT...
test-img

sticky bit

Posts

Questions

Blogs

Jobs