PostgresSQL : How to Parse XML with Attributes. Insert into a Table.

PostgresSQL : How to Parse XML with Attributes. Insert into a Table.
Master Parsing XML which contains Attributes.
Learn how to use the function XPATH, to parse the XML and return an ARRAY.
Learn how to use Raise NOTICE, great for debugging.
How to READ XML attributes in postgreSQL
How to extract the value from the Attribute from XML using Postgresql.
Parse XML document with PostgreSQL using XPATH.

Insert into a Postgresql Table, data that was extracted from an XML Document.

Table of Contents
-----------------------
00:00 Intro
00:03 Github - get the source code
00:17 Postgresql Version
00:30 Create temporary table and declare variables
01:08 Introduce XML_DATA and declare variables
02:32 Create FOR LOOP
04:00 Initialize variables and parse XML using XPATH
06:25 More fields parsed using XPath, introduction to ATTRIBUTES
10:33 Insert data into table
11:27 select data from table, and add additional XML
12:15 Closing comments; be kind, leave a comment for other programmers to learn from!

--postgresql programming
--postgresql function

#softwarenuggets @SoftwareNuggets