Amador Alvarez 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$$;
--
Sent via pgsql-admin mailing list (pgsql-a
Amador Alvarez writes:
> Hi there,
> I would like to know if it is possible to get the date when the
> different schemas were created, as I want to write an script to dump
> only the latest schemas, the latest month created schemas for
> instance.
You could attach the creation date to the schema
