How to guide copilot to use quotes with table names with chat responses

[diginikkari]

I have been playing with copilot-pg and I like it a lot 💪. One thing I have issues is that in chat answers table names are without quotes. Our schema is using case sensitive table names so I have to edit query blocks in answers to include quotes for table names. I wonder if there is any way to give more guidance for copilot for settings for this kind of needs?

[robconery]

Hmmm - I know that in "normal" mode in chat, without the participant, you can tell copilot to "use quotes to escape the table names" and will redo the code. Postgres convention is lower_case and it actively enforces it, unless you escape (as I'm sure you know), which probably why you're getting back unescaped SQL.

I wonder if you added "escape the table names" to your prompt for @pg if it would do it?

[diginikkari]

Adding "escape the table names" to prompt gave the query with quotes. So if there would be possible to add "extra" prompt with extension settings, this could be possible?

[diginikkari]

I tried also the new experimental github.copilot.chat.experimental.codeGeneration.instructions -setting but is looks like it will not read these instruction when using chat participant.