Friday, December 14, 2018

Replace unwanted characters 



Select REPLACE(REPLACE(ColumnXXX, CHAR(13),' '), CHAR(10),' ')
at No comments:
Subscribe to: Comments (Atom)

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

SELECT xmltable.* FROM xmldata, XMLTABLE('//ROWS/ROW' PASSING data COLUMNS id int PATH ...