Should escape table/columns for default query in SQLPro for Postgres

[lifeiscontent]

Describe the bug in a DB that has a database such as #tmp_1st_week the default query should be valid

To Reproduce Steps to reproduce the behavior:

1. Create table with special chars
2. double click on table
3. see invalid SQL

Expected behavior

SELECT * FROM public."#tmp_1st_week" LIMIT 1000;

Actual behavior

SELECT * FROM public.#tmp_1st_week LIMIT 1000;

Screenshots

Environment details (please complete the following information):

• Device: Macbook Pro
• OS: Mac OS 14.4.1
• SQLPro app Version SQLPro for Postgres Version 2024.21 (Build 1047899.5)
  • Installation source: App Store
  • Target database server PostgreSQL

Additional context Add any other context about the problem here.

Issues will be closed until environmental details are provided.

If the above template is not completed, issues with be closed with the statement Issue has been closed. Please edit the initial post (or create a new issue) and follow the template. Once completed, the issue may be reopened.

[hankinsoft]

Ahhh, thanks for those details. I've got this reproduced and fixed. A build has been submitted to apple. It usually takes about 24 hours for it to be approved.

[hankinsoft]

Latest build is up and has this all sorted. If you get the chance please let me know if everything is working as expected.

[lifeiscontent]

@hankinsoft thanks again for a very quick turn around 🎉