search

sosedoff / pgweb

Cross-platform client for PostgreSQL databases
https://sosedoff.github.io/pgweb
MIT License
8.63k stars 732 forks source link

Uppercase table names must be quoted #77

Closed joshstrange closed 9 years ago

joshstrange commented 9 years ago

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 commented 9 years ago

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

lfx commented 9 years ago

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

sosedoff commented 9 years ago

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