From: | Arthur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru> |
---|---|
To: | ramsiddu007 <ramsiddu007(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Get attributes names |
Date: | 2019-01-24 09:54:32 |
Message-ID: | b7bb9f68-595c-3dff-3dd8-e215eb9b28fe@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 24.01.2019 11:54, ramsiddu007 wrote:
> Dear all,
> I hope you are all doing well. Today i got one
> requirement, for that i need attribute names as below example.
>
> Xml:
> <emp>
> <emp_details emp_id="101" emp_name="tom" dept="development"/>
> </emp>
>
> In the above sample input xml, i want attributes list of emp_deails like.
> Attributes
> ___________
> emp_id
> emp_name
> dept
>
>
> Thanking you,
>
In PostgreSQL 11 (and 10 I think) you can do something like this:
=# CREATE TABLE xmldata AS SELECT xml $$
<emp>
<emp_details emp_id="101" emp_name="tom" dept="development"/>
</emp>
$$
as data;
=# SELECT xmltable.*
FROM xmldata,
xmltable('/emp/emp_details/@*' passing data
columns atrr text path 'name()');
atrr
----------
emp_id
emp_name
dept
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2019-01-24 10:01:06 | Re: Need a command to take the backup of the child tables along with its master table. |
Previous Message | Raghavendra Rao J S V | 2019-01-24 09:40:02 | Need a command to take the backup of the child tables along with its master table. |