Home Assistant PostgreSQL Statement Sensor erstellen

Entweder via GUI oder YAML möglich.

Database URL:

postgresql://__USER__:__PASSWORD__@__SERVER__/__DATABASE__

Statement:

SELECT  "examplecolomn1" AS "col1" FROM "public"."table" ORDER BY "timestamp" DESC LIMIT 1;