PostgreSQL array in form type: value

Question

Is there any way to create an array in PostgreSQL which contains multiple data types in form type:value?

For example, one of the table records should be an array with values height:190, color:black etc. If it isn't possible with arrays, how could I mannage this other way?

you can use json as column type. You read about the same on postgres official page. — Fahad Anjum
– Fahad Anjum, Commented May 9, 2017 at 10:08
"how could I manage this other way?" -- Captain Obvious here ... By using multiple columns, and possibly an associated table. (If you don't want to go the JSON route, that is.) — Tom Lord
– Tom Lord, Commented May 9, 2017 at 10:08

Vao Tsun · Accepted Answer · 2017-05-09 10:18:11Z

1

https://www.postgresql.org/docs/current/static/hstore.html

This module implements the hstore data type for storing sets of key/value pairs within a single PostgreSQL value

t=# select ('height=>190, color=>black')::hstore;
              hstore
-----------------------------------
 "color"=>"black", "height"=>"190"
(1 row)

https://www.postgresql.org/docs/current/static/datatype-json.html

JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 7159. Such data can also be stored as text, but the JSON data types have the advantage of enforcing that each stored value is valid according to the JSON rules.

t=# select '{"height":190, "color":"black"}'::json;
              json
---------------------------------
 {"height":190, "color":"black"}
(1 row)

edited May 9, 2017 at 10:18

answered May 9, 2017 at 10:09

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL array in form type: value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related