Subscribing to Views (in addition to Tables)

Feature request


I'm not sure if this exists already but I couldn't get it to work. It would be nice if we could subscribe to views in addition to tables. I'm not familiar enough with the system to say if this is easy, hard or possible.

The problem


I want to give public access to certain columns in a table (instead of rows). I learned that views is a solution, but I don't seem to be able to use views with realtime.

Solution I'd like

Given messages_public is a view based on messages, the usage might look like this:


Or this


Describe alternatives you've considered

Currently I'm just manually polling the view instead of a realtime subscription, which isn't ideal.