Short answer
Supabase’s API can’t see a table with that name. First check the table exists in the project your app’s URL points at, since a migration that never ran, or a staging project, would leave it missing. If it exists, reload the schema cache with NOTIFY pgrst, 'reload schema'; in the SQL Editor. If it lives outside the public schema, expose that schema or name it in the query.
Why the API can’t see the table, and the fix
01
The table isn’t in this database
“Caused when the table specified in the URI is not found.” Supabase, PostgREST error codes
We also check the obvious first: open the Table Editor of the project your app’s Supabase URL points at, not the one you think it uses. If the table is missing, the migration that creates it didn’t run there. Run it against that project, and check the staging project as well.
02
The schema cache hasn’t caught up
“To refresh your PostgREST schema, go to your project Dashboard, and open the SQL Editor.” Supabase, Reload/refresh postgrest schema
The API keeps a cache of your tables. If the table exists but the API still can’t see it, reload the cache from the SQL Editor:
NOTIFY pgrst, 'reload schema';03
The table is in another schema
“When multiple schemas are exposed, the first entry in the list is treated as the default, so PostgREST resolves unqualified object names only against that schema.” Supabase, PostgREST not recognizing objects in schema
Only the public schema is exposed by default. A custom schema has to be added to Exposed schemas in the API settings and granted to the API roles. With several exposed schemas, a table outside the default one needs .schema('your_schema') in the query, or the client created with that schema.
Checked against the vendor’s docs on : Supabase docs: PostgREST error codes; Supabase troubleshooting: Reload the PostgREST schema; Supabase troubleshooting: Objects in an exposed schema; Supabase docs: Using custom schemas.
Rather hand it over?
Fixed scope, fixed price, paid upfront. The work happens in writing; no call needed.
- from $450App Fix TicketOne reproducible bug in an existing mobile or web app, diagnosed and fixed.See scope and start
- from $450AI-Built App RescueA Lovable, Bolt or Cursor app checked end to end in 3 days, then its worst problems fixed at a fixed price.No issues worth fixing, no charge. If the Launch Check finds nothing rated medium or higher, Simon refunds the full $450. You keep the report either way.See scope and start
Related: Supabase migration failed (db push) · Supabase staging environment · Supabase project paused · Supabase public storage bucket