Thanks a lot Hari, very resourceful, you have been very helpful.
cheers, A.A. On 06/07/2012 12:47 AM, hari.fu...@gmail.com wrote:
Amador Alvarez<aalva...@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$$;
-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
