Unable to change default schema in database connection

[thomasroordaGiG]

Hi all,

I have just installed this extension, and connected to our database succesfully. However, for the SQL scripts to work, I need to connect to a specific schema within the database connection. Currently, the execution throws the error of ¨relation ´x´ does not exist.¨ I am using the newest version of Visual Code and SQLTools, and I am using PostgreSQL. It seems to default to the public schema, but I need to have the vcs schema connected to by default, see image. This is where the tables are located that I want to use. Can anyone point me to where I can change this setting?

Kind regards,
Thomas

[gjsjohnmurray]

Can you use the SET search_path TO vcs syntax described in docs here?

[thomasroordaGiG]

@gjsjohnmurray Thanks for the reply. This does work, however I was looking for a way to configure VSCode to do this. I guess that is not a possibility? I used to work with dbeaver, which does have this functionality.

[gjsjohnmurray]

The PostgreSQL driver would need enhancing to do this. I have added the 'feature request' label but can't promise it will be implemented.