Thanks a lot Hari, very resourceful, you have been very helpful.
cheers, A.A. On 06/07/2012 12:47 AM, [email protected] wrote:
Amador Alvarez<[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
