vscode-sqltools icon indicating copy to clipboard operation
vscode-sqltools copied to clipboard

Database object names should maintiain case sensitivity

Open gajakannan opened this issue 4 years ago • 1 comments

PgSql Table Name is defined as ProperCase, when the query is executed it is converting everything to lowercase and reports an error that the table doesnt exist

To Reproduce Steps to reproduce the behavior:

  1. Create a Pgsql connection
  2. Expand the database to get to the table
  3. Make sure Pgsql has at least one table with ProperCase
  4. In the query editor type SELECT * FROM <TableName>
  5. Click <Run on active connection> from query editor

Expected behavior Should get list of table row values in the output window

Screenshots If applicable, add screenshots to help explain your problem.

errors out that "relation 'tablename' does not exist"

pgsqlerror

Desktop:

  • SQLTools Version [0.23]
  • VSCode Version: [1.52.1]
  • OS: [Windows]
  • Driver:
    • [ ] PostgreSQL
  • Database version: [PostgreSQL 13]

Additional context If selected from an all lowercase named table this feature works fine

gajakannan avatar Dec 17 '20 23:12 gajakannan

I'm encountering this issue as well. Any update?

joe-gre avatar May 15 '23 21:05 joe-gre