Ygthkb

When was drinking water recognized as crucial in marathon running?

Analog Mute Circuit - Simplest Solution

What happened to QGIS 2.x LTR?

How do you say "powers of ten"?

I can't die. Who am I?

Graphing random points on the XY-plane

How to evaluate the limit where something is raised to a power of x?

Don't know what I’m looking for regarding removable HDDs?

Do higher etale homotopy groups of spectrum of a field always vanish?

Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?

Make me a metasequence

Is divide-by-zero a security vulnerability?

Can a space-faring robot still function over a billion years?

Is there a full canon version of Tyrion's jackass/honeycomb joke?

Are paired adjectives bad style?

Why is working on the same position for more than 15 years not a red flag?

Can we carry rice to Japan?

Is there a math equivalent to the conditional ternary operator?

Heating basement floor with water heater

Why do members of Congress in committee hearings ask witnesses the same question multiple times?

Dystopian novel where telepathic humans live under a dome

What am I? I am in theaters and computer programs

VAT refund for a conference ticket in Sweden

Is the withholding of funding notice allowed?

How to import json table into PostgreSQL table?

Mixed search in multiple columnsPostgresql: Aggregate objects into an (json) array (subquery issues)Structure for storing table data, lists, text, pictures within PostgreSQL JSON fieldPostgresql json column to viewPostgreSQL bug with JSON type?How to insert nested JSON arrays into a table?Multiple rows into jsonPostgresql 9.5 JSON problemsJSON Query in PostgreSQLHow to Insert JSON data to BYTEA column in the table in POSTGRESQL?

0

I'm trying to import some tables into a PostgreSQL db that have been stored as json files. Example data:

[{

"token": "a978f9793a594d11860e9cf7962996d7",

"name": "vehicle.moving",

"description": "Vehicle is moving."

},

{

"token": "95e38bf08c2842f39f2d64ba8152b265",

"name": "vehicle.stopped",

"description": "Vehicle, with a driver/rider in/on it, is currently stationary but has an intent to move."

}]

Would like the result to look like:

token                            | name            | description

---------------------------------+-----------------+--------------------

a978f9793a594d11860e9cf7962996d7 | vehicle.moving  | Vehicle is moving.

95e38bf08c2842f39f2d64ba8152b265 | vehicle.stopped | Vehicle, with a driver/rider in/on it, is currently stationary but has an intent to move.

My SQL currently looks like this:

set content `type "F:Datasetsattribute.json"`

insert into attribute select * from jsonb_array_elements(:'content');

Which just adds rows of quoted json to my table.
Have been bashing at this all day (SQL rookie) and would be very grateful for help.

json

share|improve this question

asked 15 mins ago

tinyMindtinyMind

11

New contributor

tinyMind 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'm trying to import some tables into a PostgreSQL db that have been stored as json files. Example data:

[{

"token": "a978f9793a594d11860e9cf7962996d7",

"name": "vehicle.moving",

"description": "Vehicle is moving."

},

{

"token": "95e38bf08c2842f39f2d64ba8152b265",

"name": "vehicle.stopped",

"description": "Vehicle, with a driver/rider in/on it, is currently stationary but has an intent to move."

}]

Would like the result to look like:

token                            | name            | description

---------------------------------+-----------------+--------------------

a978f9793a594d11860e9cf7962996d7 | vehicle.moving  | Vehicle is moving.

95e38bf08c2842f39f2d64ba8152b265 | vehicle.stopped | Vehicle, with a driver/rider in/on it, is currently stationary but has an intent to move.

My SQL currently looks like this:

set content `type "F:Datasetsattribute.json"`

insert into attribute select * from jsonb_array_elements(:'content');

Which just adds rows of quoted json to my table.
Have been bashing at this all day (SQL rookie) and would be very grateful for help.

json

share|improve this question

asked 15 mins ago

tinyMindtinyMind

11

New contributor

tinyMind 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'm trying to import some tables into a PostgreSQL db that have been stored as json files. Example data:

[{

"token": "a978f9793a594d11860e9cf7962996d7",

"name": "vehicle.moving",

"description": "Vehicle is moving."

},

{

"token": "95e38bf08c2842f39f2d64ba8152b265",

"name": "vehicle.stopped",

"description": "Vehicle, with a driver/rider in/on it, is currently stationary but has an intent to move."

}]

Would like the result to look like:

token                            | name            | description

---------------------------------+-----------------+--------------------

a978f9793a594d11860e9cf7962996d7 | vehicle.moving  | Vehicle is moving.

95e38bf08c2842f39f2d64ba8152b265 | vehicle.stopped | Vehicle, with a driver/rider in/on it, is currently stationary but has an intent to move.

My SQL currently looks like this:

set content `type "F:Datasetsattribute.json"`

insert into attribute select * from jsonb_array_elements(:'content');

Which just adds rows of quoted json to my table.
Have been bashing at this all day (SQL rookie) and would be very grateful for help.

json

share|improve this question

asked 15 mins ago

tinyMindtinyMind

11

New contributor

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

[{

"token": "a978f9793a594d11860e9cf7962996d7",

"name": "vehicle.moving",

"description": "Vehicle is moving."

},

{

"token": "95e38bf08c2842f39f2d64ba8152b265",

"name": "vehicle.stopped",

"description": "Vehicle, with a driver/rider in/on it, is currently stationary but has an intent to move."

}]

token                            | name            | description

---------------------------------+-----------------+--------------------

a978f9793a594d11860e9cf7962996d7 | vehicle.moving  | Vehicle is moving.

95e38bf08c2842f39f2d64ba8152b265 | vehicle.stopped | Vehicle, with a driver/rider in/on it, is currently stationary but has an intent to move.

set content `type "F:Datasetsattribute.json"`

insert into attribute select * from jsonb_array_elements(:'content');

share|improve this question

asked 15 mins ago

tinyMindtinyMind

11

New contributor

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

share|improve this question

asked 15 mins ago

tinyMindtinyMind

11

New contributor

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

asked 15 mins ago

tinyMindtinyMind

11

New contributor

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

asked 15 mins ago

tinyMindtinyMind

11