Is there a way to get a postgresql table state update by an external java process?

Question

PostgreSQL

Preconditions: there is a periodically growing table in postgresql and a java process in which we would like to process newly received data
. Assumption: it is not rational to request data from this table from a java process and check them.
Question: Is there a way to subscribe a java process to table updates?

Answer 1

https://www.postgresql.org/docs/current/logicaldec...
Logical Decoding Framework.
Either you write to pgq as a trigger, your application reads the pgq queue. It's much easier.

Answer 2

Make a trigger send NOTIFY on changes and execute LISTEN in the program .