double quotes are removed automatically

[witwall]

When I copy only a field with double quotes, the double quotes will be removed automatically, but as you know, PostgreSQL needs double quotes if the field begins with upper case.

for example, "Product_id" after copy and paste, will only Product_id left.
but if I copy and paste count(distinct "Product_ID"), the double quotes will be remained.

[serge-rider]

It is not a bug, it is a feature (DBeaver extracts SQL queries from source code).
Workarounds:

• Press ctrl+z after paste (it will revert source code conversion)
• Disable source code extraction at all:
  

[carlosspohr]

Hi there,

I didn't know this option, I did some tests and, it's so useful copying / paste from statements as concatenated String from Eclipse for instance. So, copying this String statement:

Then, pasting it, I get extracted SQL in one line only...What do you think if you add SQL Format for extracted SQL?

[serge-rider]

Extracted SQL will look exactly as in your app program.
For instance if you'd use \n \t characters in your source code then they will be converted into line feeds/tabs.
I don't think we need implicit SQL formatting here. You can always do it with ctrl+alt+f.

[serge-rider]

But maybe I should leave line feeds even if they are outside of quotes..

[carlosspohr]

Uhmmm, yep, it's make sense.