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