Parameters subtitution like psql quetion

[migueldeblas]

System information:

• Windows 10
• DBeaver 7.3.0 eclipse plugin

Connection specification:

• Postgresql 12.5

Describe your question:

I work with psql -v/--set/--variable options scripts

I need to use:
:"param" because postgresql has case sensitive objects name;

The method of use is described here:
https://www.postgresql.org/docs/12/app-psql.html#APP-PSQL-INTERPOLATION

In short if I use:
psql -v myschema=SchemaOne -v code=mycode
select count(*) from :"myschema"."TableExample" where code = :'mycode';
...

This code works in pgsql but fails in dbeaver.
SQL Error [42601]: ERROR: syntax error at or near ":"
(If Ichange :"xxx" or :'xxx' for :xxxxxx works)

I see a dbeaver parameter configuration (? and :) but I don't know how to configure it.
Is it a bug, is it not implemented or am I doing something wrong?

[kseniiaguzeeva]

Please delete quotes from parameter names:
select count(*) from :myschema.TableExample where code = :mycode

You will be able to add them in the value field for the value after pressing Execute button.

Please ask to reopen the ticket if it is not your case.

[migueldeblas]

Yes, if I delete quotes works in dbeaver (my develop tool) but doesn't work in psql that is the run tool used in production.
In postgresql it is mandatory double quote for upper/capitalize object names.
Changing to ":myschema" also doesn't work.

[kseniiaguzeeva]

Please try to use following syntax ${xxx}. This is what we can offer from DBeaver side.