Postgress - Read a XML file from a postgress table XML column

SELECT xmltable.* FROM xmldata, XMLTABLE('//ROWS/ROW' PASSING data COLUMNS id int PATH '@id', "COUNTRY_NAME" text, country_id text PATH 'COUNTRY_ID', size_sq_km float PATH 'SIZE[@unit = "sq_mi"]', size_other text PATH 'concat(SIZE[@unit!="sq_km"], " ", SIZE[@unit!="sq_km"]/@unit)', premier_name text PATH 'PREMIER_NAME' DEFAULT 'not specified'); SELECT xmltable.* FROM table1, XMLTABLE('//Project/Tasks/Task' PASSING xdata COLUMNS "Name" text); SELECT xmltable.* FROM "ProjXML", XMLTABLE('//Project/Tasks/Task' PASSING Document COLUMNS "Name" text, "BuildNumber" text PATH "../,