FLOAT Data Type - SQL Server to PostgreSQL Migration

In SQL Server, FLOAT(p) data type stores approximate single or double precision floating point numbers. In PostgreSQL you can use REAL and DOUBLE PRECISION data types.

SQL Server:

  CREATE TABLE specs
  (
    value   FLOAT,
    value2 FLOAT(24),
    value3 FLOAT(53)
  );

PostgreSQL:

  CREATE TABLE specs
  (
    value   DOUBLE PRECISION,
    value2 REAL,
    value3 DOUBLE PRECISION
  );

Conversion summary:

For more information, see SQL Server to PostgreSQL Migration.