Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Generate schema fields with double quotes #16

Open
lyqht opened this issue Oct 3, 2022 · 1 comment
Open

Generate schema fields with double quotes #16

lyqht opened this issue Oct 3, 2022 · 1 comment
Labels
bug Something isn't working

Comments

@lyqht
Copy link

lyqht commented Oct 3, 2022

Description

In one of my projects that used supabase-schema to generate the SQL scripts, many of fields use camelcase, hence the generated script by default does not work since Postgres require camelcase/uppercase fields to be included in double quotes. e.g. sourceRepo needs to be "sourceRepo"

Example Screenshot

Current fields that are generated

image

Running the above script will create the fields all in small caps, and all the calls to supabase DB from app will fail due to wrong schema.

Suggested solution

Hence, this issue is requesting for the generated script to include quotes.
P.S. I can also work on this if u can include hacktoberfest label to this 😄

@zernonia
Copy link
Owner

zernonia commented Oct 3, 2022

Thanks @lyqht for reporting this! You are right that camelCase need to be wrapped in double quotes.
I will set this as Bug. 😁

@zernonia zernonia added the bug Something isn't working label Oct 3, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants