search

zernonia / supabase-schema

Secured & Simple Supabase Schema Visualizer
https://supabase-schema.vercel.app/
MIT License
809 stars 47 forks source link

Views shown as Tables #3

Closed semihpolat closed 3 years ago

semihpolat commented 3 years ago

Hi, Firstly it is great job! we needed it too much!

The issue is I have tables and views from tables but when I wanna export SQL views shown as tables.

zernonia commented 3 years ago

Hi @semihpolat . Glad to hear that you are using this tool! And thank you so much for this issue.

I realized that View is also generated in the OpenAPI schema, thus signaling that it is a Table (which is not). I will look into this and try to differentiate Tables and Views on the dashboard, so that users can differentiate easily, and finally export the appropriate tables only.

Thank you! 😄

zernonia commented 3 years ago

Fix the View in Export SQL. I had to remove the views from the export because the OpenAPI endpoint doesn't have information regarding how these views were created, unless I have the Database Auth & Endpoint.

So, simply click the Fetch button again to update the table to show the latest udpate.

Thank you!

https://github.com/zernonia/supabase-schema/commit/b5cb8d8bfbe1c3f1d9a5cc75d2fe8176cf5db746