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