Re: Can schemas be ordered regarding their creation time ? - Mailing list pgsql-admin

Amador Alvarez <aalvarez@d2.com> writes:

> Any idea on doing ("COMMENT ON SCHEMA x IS 'y'") as 'y' variable?

You could use PL/pgSQL's "EXECUTE" for that:

DO $$BEGIN
  EXECUTE 'COMMENT ON SCHEMA myschema IS ''Created ' ||
          current_timestamp || '''';
END$$;