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

Uppercase table names must be quoted #77

Closed
joshstrange opened this issue Jan 18, 2015 · 3 comments
Closed

Uppercase table names must be quoted #77

joshstrange opened this issue Jan 18, 2015 · 3 comments

Comments

@joshstrange
Copy link

This may be connected to both #29 and #16 (if not the same issue). I have a table that starts with a capital letter (eg: "Users") and if I try to do a query 'SELECT * FROM Users' it complains about there being no "users" table. However if I do 'SELECT * FROM "Users"' then it works.

I don't have a lot of experience with pgsql (come from a mysql background) and I rarely use uppercase in my table names (the ORM I'm using did it). The structure tab works just fine, it's just queries that are effected. Again, this may be expected behavior but I wanted to open an issue to make sure. Thanks!

@sosedoff
Copy link
Owner

Which pgweb version are you using? Also on which OS ?

@lfx
Copy link

lfx commented Feb 19, 2015

Hello, @joshstrange I think this may be your case http://blog.lerner.co.il/quoting-postgresql/

@sosedoff
Copy link
Owner

Closing this issue unless there's a problem. No feedback received.

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants