How to create and store array of objects in postgresql

Question

In postgresql allowed array types or integer and text.But i need to create array of objects.how can i do that.

myarray text[];   //for text ['a','b','c']
myarray integer[];  //for integer[1,2,3]

I need to create the array like below

[{'dsad':1},{'sdsad':34.6},{'sdsad':23}] 

I dont want to use JSON type.Using array type i need to store the array of objects.

Answer 1

If you're running Postgres 9.2+, you can use the JSON type.

For example, we could do

create table jsontest (id serial primary key, data json);
insert into jsontest (data) values ('[{"dsad":1},{"sdsad":34.6},{"sdsad":23}]');

And query the data with

select data->1 from jsontest;
{"sdsad":34.6}