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
