PostgreSQL table names not quoted: UndefinedTable relation "public.whatever" does not exist for table "Whatever"

[isosphere]

Small description

Connected to a local PostgreSQL database. PgTablesSheet looks good. Press "Enter" on any table that is not exclusively lowercase, get the error in the title.

Try with another table, and always get InFailedSqlTransaction: current transaction is aborted

Expected result
I should see the table I selected

Actual result with screenshot

If you get an unexpected error, please include the full stack trace that you get with Ctrl-E.

As you can see from the stack trace, the table identifier is not quoted. In PostgreSQL, public.HelloWorld is interpreted as public.helloworld. If the actual table name is public.HelloWorld, you have to use quotes. This applies for columns, too. You can solve this by always quoting identifiers.

Additional context
Please include the version of VisiData and Python.

VisiData 2.11,1, Python 3.10.4

[isosphere]

I think we just have to change:

visidata/visidata/loaders/postgres.py

Line 129 in 9c31e8d

with self.sql.cur(f"SELECT * FROM {source}") as cur:

To read:

with self.sql.cur(f'SELECT * FROM "{source}"') as cur:

[saulpw]

@isosphere would you be willing to test that change and submit a PR?

[isosphere]

with self.sql.cur(f'SELECT * FROM "{source}"') as cur:

PR submitted; my proposed solution in this quote was not enough, as "public.TableName" refers to the literal object named "public.TableName", not schema public, table TableName. I've quoted them separately, which works.