Redshift Support

[expired user #10723]'s profile image [expired user #10723] posted 7 years ago in General Permalink

It appears that when you add a E' (because this works on Postgres) on commands such as:

SET search_path TO E'public'; /* ERROR: syntax error at or near "'public'" LINE 1: SET search_path TO E'public'

The net result for Redshift is an error. I have found in your dbconnection.pas code that the E is added for Postgres, and since I invoke the Postgres dialog because Postgres/Redshift are similar, I get the error. Any thoughts on how to avoid this error?

ansgar's profile image ansgar posted 7 years ago Permalink

I know nothing about Redshift. If that's a PostgreSQL replacement with some differences to PostgreSQL, than the code needs some additions. And "Redshift" needs to be added to HeidiSQL's available net types.

Please login to leave a reply, or register at first.