HeidiSQL with Amazon Redshift

[expired user #9697]'s profile image [expired user #9697] posted 8 years ago in General Permalink

Hi,

I've just started working with an Amazon Redshift database and I've been trying out various clients. HeidiSQL seems to be the fastest client, but there is one drawback. I can see the schema on the database in the object viewer, but I can't see anything at a lower level than that and I'd love to be able to explore the tables within a schema. I'm able to explore in Aginity and Tableau (not quite the same sort of tool). When I click on a schema, this is the command and error that occurs:

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

Anyone know of a fix or workaround for this?

Robbie

[expired user #9882]'s profile image [expired user #9882] posted 8 years ago Permalink

Hi,

I have the same issue with Amazon Redshift. Probably HeidiSQL run escape E letter as default. Below is the result when I just tried without E letter in query tab.

------------------------
set search_path to E'xxxxx', E'public';
/* ERROR:  syntax error at or near "'jp_dwh'"
LINE 1: set search_path to E'xxxxx', E'public'
                            ^ */

set search_path to 'xxxxx', 'public';
/* Affected rows: 0  Found rows: 0  注意: 0  Duration for 1 query: 0.000 sec. */
--------------------

So we should wait for the bugfix...

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