Automatic Quote insertion
SELECT column FROM table;
When I select the column name or any text and press Single or Double quote key, The column name should be surrounded by that quote:
SELECT [column] FROM table; -- [column] => selected text
Exptected:
SELECT "column" FROM table;
-- OR --
SELECT 'column' FROM table;
Currently it just replaces the selected text with quote:
SELECT ' FROM table;
-
AdminDevart (_, Devart) commented
Hi there,
Thank you for reaching out to us!
Please, note that our Product team has just confirmed that the current behavior is an expected behavior and we do not plan in the near future change it.
Also, you can follow our releases and check the Revision history:
https://www.devart.com/dbforge/postgresql/studio/revision_history.html
There is always some information regarding improvements and fixes.
Best,
Devart Support Team -
hsw commented
Agree.
Add option in settings to enclose selected text in quotation marks.
It helps to simplify working with identifiers with mixed upper/lower case.
Look how it's done in pgAdmin (it also works in VS Code by default):
https://i.imgur.com/c6u8ASr.gif