Sfrgttk

Combinations of multiple lists

How do I write bicross product symbols in latex?

Memorizing the Keyboard

Can one be a co-translator of a book, if he does not know the language that the book is translated into?

Infinite Abelian subgroup of infinite non Abelian group example

Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?

AES: Why is it a good practice to use only the first 16bytes of a hash for encryption?

Is it unprofessional to ask if a job posting on GlassDoor is real?

Could gravitational lensing be used to protect a spaceship from a laser?

SSH "lag" in LAN on some machines, mixed distros

Is it possible to run Internet Explorer on OS X El Capitan?

Did Shadowfax go to Valinor?

How to prevent "they're falling in love" trope

What is the most common color to indicate the input-field is disabled?

What's the difference between 'rename' and 'mv'?

Is the Joker left-handed?

A reference to a well-known characterization of scattered compact spaces

Why does Kotter return in Welcome Back Kotter

Stopping power of mountain vs road bike

Why are electrically insulating heatsinks so rare? Is it just cost?

What exploit are these user agents trying to use?

Neighboring nodes in the network

Can I ask the recruiters in my resume to put the reason why I am rejected?

Has there ever been an airliner design involving reducing generator load by installing solar panels?

Appending data from JSON file to a table

CRUD operations on json dataPostgreSql : flatten json array dataQuerying JSONB in PostgreSQLStructure for storing table data, lists, text, pictures within PostgreSQL JSON fieldHow to Insert into with postgresql and JSONBSQL Server 2016 Nested JSON ArrayList JSON array in MySQL as rowsWhich is more efficient for searches on JSON data in Postgres: GIN or multiple indexed columns?merge json online postgresql 10How do I modify a JSON object?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I am using two columns from the iris dataset as an example - sepal_length and sepal_width.

I have two tables

create table iris(sepal_length real, sepal_width real);, and

create table raw_json(data jsonb);

And inside the JSON file I have data like this

[{"sepal_width":3.5,"sepal_length":5.1},{"sepal_width":3.0,"sepal_length":4.9}]

First thing I do is copy raw_json from '/data.json';

So far I have only been able to figure out how to use jsonb_array_elements.

select jsonb_array_elements(data) from raw_json; gives back

           jsonb_array_elements            

-------------------------------------------

 {"sepal_width": 3.5, "sepal_length": 5.1}

 {"sepal_width": 3.0, "sepal_length": 4.9}

I want to insert (append actually) the data from raw_json table into iris table. I have figured out that I need to use either jsonb_to_recordset or json_populate_recordset. But how?

Also, could this be done without the raw_json table?

PS - Almost all the existing SE questions use a raw json string inside their queries. So that didn't work for me.

postgresql json

share

asked 2 mins ago

Jeet ParekhJeet Parekh

101

New contributor

Jeet Parekh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I am using two columns from the iris dataset as an example - sepal_length and sepal_width.

I have two tables

create table iris(sepal_length real, sepal_width real);, and

create table raw_json(data jsonb);

And inside the JSON file I have data like this

[{"sepal_width":3.5,"sepal_length":5.1},{"sepal_width":3.0,"sepal_length":4.9}]

First thing I do is copy raw_json from '/data.json';

So far I have only been able to figure out how to use jsonb_array_elements.

select jsonb_array_elements(data) from raw_json; gives back

           jsonb_array_elements            

-------------------------------------------

 {"sepal_width": 3.5, "sepal_length": 5.1}

 {"sepal_width": 3.0, "sepal_length": 4.9}

I want to insert (append actually) the data from raw_json table into iris table. I have figured out that I need to use either jsonb_to_recordset or json_populate_recordset. But how?

Also, could this be done without the raw_json table?

PS - Almost all the existing SE questions use a raw json string inside their queries. So that didn't work for me.

postgresql json

share

asked 2 mins ago

Jeet ParekhJeet Parekh

101

New contributor

Jeet Parekh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I am using two columns from the iris dataset as an example - sepal_length and sepal_width.

I have two tables

create table iris(sepal_length real, sepal_width real);, and

create table raw_json(data jsonb);

And inside the JSON file I have data like this

[{"sepal_width":3.5,"sepal_length":5.1},{"sepal_width":3.0,"sepal_length":4.9}]

First thing I do is copy raw_json from '/data.json';

So far I have only been able to figure out how to use jsonb_array_elements.

select jsonb_array_elements(data) from raw_json; gives back

           jsonb_array_elements            

-------------------------------------------

 {"sepal_width": 3.5, "sepal_length": 5.1}

 {"sepal_width": 3.0, "sepal_length": 4.9}

I want to insert (append actually) the data from raw_json table into iris table. I have figured out that I need to use either jsonb_to_recordset or json_populate_recordset. But how?

Also, could this be done without the raw_json table?

PS - Almost all the existing SE questions use a raw json string inside their queries. So that didn't work for me.

postgresql json

share

asked 2 mins ago

Jeet ParekhJeet Parekh

101

New contributor

Jeet Parekh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

           jsonb_array_elements            

-------------------------------------------

 {"sepal_width": 3.5, "sepal_length": 5.1}

 {"sepal_width": 3.0, "sepal_length": 4.9}

share

asked 2 mins ago

Jeet ParekhJeet Parekh

101

New contributor

Jeet Parekh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 2 mins ago

Jeet ParekhJeet Parekh

101

New contributor

Jeet Parekh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

Jeet ParekhJeet Parekh

101

New contributor

Jeet Parekh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

Jeet ParekhJeet Parekh

101