The Postgres Changes extension listens for database changes and sends them to clients which enables you to receive database changes in real-time.
Guide
Listening to Postgres Changes with Flutter
Listening to real-time changes on the database with Flutter