Listen changes to a specific column

Hello, is it possible to listen for change in realtime for a specific column ? I have a

documents

documents

table in my database:

create table documents (
  id uuid default uuid_generate_v4() not null,
  title text not null,
  content text not null,
  -- ... other columns
)

create table documents (
  id uuid default uuid_generate_v4() not null,
  title text not null,
  content text not null,
  -- ... other columns
)

I would like to get all the document titles in sync with my app state. So I only need to listen for changes on the

title

title

column, but not on the

content

content

column (it would be a waste to download the payload each time the

content

content

changes while I only need the

title

title

?).

So is it possible to listen for changes on a specific column? Or is there an alternative solution?

Supabase•4y ago•

1 reply