Files
supabase/apps/docs/content/troubleshooting/refresh-postgrest-schema.mdx

28 lines
605 B
Plaintext

---
title = "Reload/refresh postgrest schema"
topics = [ "database" ]
keywords = [ "schema", "postgrest" ]
database_id = "b76ac13f-db24-4d19-9d00-af60c978cd26"
[[errors]]
http_status_code = 400
code = "bad_request"
message = "Could not find a relationship between X and Y in the schema cache"
---
To refresh your PostgREST schema, go to your project **Dashboard**, and open the **SQL Editor**.
Then, paste the following SQL statement:
```sql
NOTIFY pgrst, 'reload schema';
```
And click on **Run**.
You should see a confirmation message under the **Results** tab:
```
Success. No rows returned
```