Should this work with Redshift?

[martin1537]

I'm unable to connect to a Redshift PostgreSQL server using this tool. I know AWS has implemented their own flavor. Is this tool meant to connect to it? The error I'm getting is:

pgsql: Failed to expand node: unrecognized privilege type: "connect"

I can connect to the server via other methods using the same credentials. dBeaver and SQLTools extension in VSCode.

Thanks!

[mmcfarland]

Thanks @martin1537 -- yes, we'd like to support Redshift if practical. Thanks for the log message; we'll look into this.

[DavidJayMartin]

This would be great. The alternative is to use AWS's Toolkit extension which requires an AWS account login. As only a consumer of data from the the PostgreSQL instance, we only have a login for the database and not an AWS account, so the AWS documented solution is a no-go. Thanks!

[martin1537]

Oops, wrong account. :) Thanks!