UNIQUEIDENTIFIER Data Type - SQL Server to PostgreSQL Migration

SQL Server UNIQUEIDENTIFIER data type stores Universally Unique Identifiers (UUID) or GUID data. In PostgreSQL you can use UUID data type.

SQL Server:

  -- Sample table 
  CREATE TABLE specs 
  (
     data UNIQUEIDENTIFIER
  );
 
  -- Inserting sample value
  INSERT INTO specs VALUES ('7F9619FF-8B86-D011-B42D-00C04FC964FF');

PostgreSQL:

  -- Sample table 
  CREATE TABLE specs 
  (
     data UUID
  );
 
  -- Inserting sample value
  INSERT INTO specs VALUES ('7F9619FF-8B86-D011-B42D-00C04FC964FF');

For more information, see SQL Server to PostgreSQL Migration.