display array field as row - Mailing list pgsql-general

From hendra kusuma
Subject display array field as row
Date
Msg-id 26dadb3d0902022012v671d9708m1e0db84f4ff1588@mail.gmail.com
Whole thread Raw
Responses Re: display array field as row
List pgsql-general
Dear all,

Does anyone know how to display an array data into row?
for exampla, I have data like this

connamecontypeconkey


kelas_pkeyp{1,2}


kelas_tahunf{2}



And I want to to display those data above like below

kelas_pkey     p     1
kelas_pkey     p     2
kelas_tahun   f      2

Do you know any sql syntax that would do?
I cannot find it in documentation
or is it not possible?

Regards
Hendra

pgsql-general by date:

Previous
From: rhubbell
Date:
Subject: Re: calculating elapsed times between timestamps
Next
From: Phoenix Kiula
Date:
Subject: Re: Smartest way to resize a column?