Generate JSON with property names that include dot using SELECT FOR JSON
I need to generate the folowing JSON payload (shortened) from a table in SQL Server. Please note the dot in the property name. This is a special syntax called OData.
json
Json extract of [‘a’,’b’,’c’]
My json is of the format [“a”,”b”,”c”]. I want to write a sql query such that
Best way to map different JSON keys to same target columns
I have CSV import data that comes from multiple vendors with 50+ different columns, and each vendor has slightly different naming.
JSON_EXRACT vs native SQL query
I was originally going to ask this on SO, but thought better of it, so I am trying my hand here.
Unique array values for this string_to_array
This is a follow-up to:
Two OPENJSON, return each array element in separate rows
I have a table where I save in JSON format the quantity that exit and return of a product.
The data saved in the two columns out_quantity and in_quantity is in array format.
Join variable number of rows in Postgres into json array
I have the following table:
Importing CSV with a json array of strings in one of the column
The columns of the CSV are of the format text (can include empty lines), date and a JSON array of strings (something like ['a', 'b', 'c']. I’ve been trying to copy that CSV to a PostgreSQL table (using psycopg2‘s copy_expert, which simply executes the given SQL COPY command, if that matters)
jsonb_array_elements() fails with “ERROR: cannot extract elements from an object”
Using: Postgres 14.2.
Objective: To get a list of all distinct countries in my table.
How to sum nested values from a JSON array based on conditions
I have a table with 3 columns in Postgres 14.2: name, name_adds, aditional.