© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
2 replies
MaGnezij

How to create an updatable view

Could anybody please help me make this view updatable. Im really strugling with it.
CREATE or replace VIEW user_notifications AS
SELECT u.user_id,n.heading,n.info,n.date,n.link,n.id,
False as seen
FROM users u,notifications n;
CREATE or replace VIEW user_notifications AS
SELECT u.user_id,n.heading,n.info,n.date,n.link,n.id,
False as seen
FROM users u,notifications n;
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

How to view / create local secrets?
SupabaseSSupabase / help-and-questions
3w ago
How to view active cron jobs?
SupabaseSSupabase / help-and-questions
3y ago
How to update data in view
SupabaseSSupabase / help-and-questions
4y ago
How to Protect Base Tables with Views? (view, security_invoker, authenticated user)
SupabaseSSupabase / help-and-questions
5mo ago