XML Data Type - SQL Server to PostgreSQL Migration

In SQL Server and PostgreSQL, the XML data type stores XML data.

SQL Server:

  -- Sample table 
  CREATE TABLE specs 
  (
     data XML
  );
 
  -- Inserting sample value
  INSERT INTO specs VALUES ('<item>Abc</item>');

PostgreSQL:

  -- Sample table 
  CREATE TABLE specs 
  (
     data XML
  );
 
  -- Inserting sample value
  INSERT INTO specs VALUES ('<item>Abc</item>');

For more information, see SQL Server to PostgreSQL Migration.