Redshift PL/SQL well I should say PL/pgSQL is out but what do you use as an authoring client?
What do I use so far for PL/pgSQL development – Aginity and psql. psql is the only tool that Amazon official supports for development of pl/pgsql – at least that is what support told me and my experience confirms – FREE GUI tools like Aginity and SQLWorkBenchJ have bugs… fortunately there are some work arounds.Well …