10 lines
317 B
SQL
10 lines
317 B
SQL
INSERT INTO public."glucose-import"
|
|
(SELECT nextval('glucose-import_id_seq'),
|
|
"glucose"."deviceSerialNumber",
|
|
"glucose"."deviceType",
|
|
"glucose".units,
|
|
"glucose".value,
|
|
"glucose".time
|
|
FROM influx.glucose
|
|
WHERE "glucose".time >= (SELECT max(time) FROM public."glucose-import")
|
|
);
|