Unable to switch schema in Redshift

[lucapircher]

What happened?

When connecting to a Redshift server with multiple schemas, the schema selector isn't available.

According to the app logs loading the schema seems to fail due to a syntax error in the query.

Steps to reproduce

1. Create a Redshift connection to a database with multiple schemas
2. Connect to that database
3. Schema selection is not available and the error from the below is logged

Expected behavior

It's possible to switch between the available schemas.

Database type

Redshift

TablePro version

0.45.0

macOS version & chip

macOS 15.7 / Apple Silicon

Screenshots / Logs

[schema] fetchSchemas failed connId=778BB5C9-C0E1-4EB5-993F-80ED6B975964 error=ERROR:  syntax error at or near "information_schema" in context "NOT LIKE 'pg\_%' ESCAPE '\'
  AND nspname <> 'information_schema", at line 2, column 61
LINE 3:   AND nspname <> 'information_schema'
                          ^ (SQLSTATE: 94)