title: How to set a schema in redshift
body: <p>I would like to know how to set the current or default schema on redshift.  Some documentation I have read states that this is possible with the SET command, but I don't believe this is accurate. I understand the search path can be altered, but I would like to know whether there is another way to set the default schema, something similar to "SET CURRENT_SCHEMA TO 'desired-schema-name'". </p>