I'm trying to set the default schema to a user in Redshift with
alter option, because I do not want it to write to the public schema by default. I am using the following order:
alter user user_1234 set search_path to atc_schema;
It does not give me any error, but when I create a table with the user without specifying the schema, it is not created in the schema indicated in the previous statement.