Add extra fields to generated view?

I have the following view
export const freqSearchView = pgView('freq_search').as(qb => qb.select().from(frequency).leftJoin(frequencyInstance, eq(frequency.id, frequencyInstance.frequencyId)))
export const freqSearchView = pgView('freq_search').as(qb => qb.select().from(frequency).leftJoin(frequencyInstance, eq(frequency.id, frequencyInstance.frequencyId)))
I would like to add a tsvector to it. For this i would need to add a extra column to the view. But how can i do so using a generated view?
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?