© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
7 replies
Kasper

syntax error at or near boolean

I'm trying to make a boolean column NOT NULL, but for some reason this is failing. any ideas why?
ALTER TABLE public.pages
ALTER COLUMN branding boolean NOT NULL;
ALTER TABLE public.pages
ALTER COLUMN branding boolean NOT NULL;

Result:
syntax error at or near "boolean"
syntax error at or near "boolean"
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

SQL Syntax Error - error at or near end
SupabaseSSupabase / help-and-questions
4y ago
[BUG]:PostgresError: syntax error at or near "NOT"
SupabaseSSupabase / help-and-questions
3mo ago
RLS Policy syntax error at or near "create"
SupabaseSSupabase / help-and-questions
3y ago
Error Error starting shadow database ERROR syntax error at or near COMMIT
SupabaseSSupabase / help-and-questions
4y ago