我使用
创建了一个表CREATE TABLE "devicedata" (
"id" serial NOT NULL PRIMARY KEY,"sn" text NOT NULL,"time" text NOT NULL,"zone" text NOT NULL,"icsmain" float NULL,"icsz1" float NULL,"icsz2" float NULL,"icsz3" float NULL,"icsboiler" float NULL,"t1" smallint NULL,"t2" smallint NULL,"t3" smallint NULL,"t4" smallint NULL,"t5" smallint NULL,"t6" smallint NULL,"t7" smallint NULL,"rt1" smallint NULL,"rt2" smallint NULL,"rt3" smallint NULL,"endswitch" smallint NULL,"ps" smallint NULL,"weather" smallint NULL)
它在 phppgadmin 中显示为浮动