From: hari.fuchs@gmail.com
To: pgsql-admin@postgresql.org
Subject: Re: Can schemas be ordered regarding their creation time ?
Date: Thu, 07 Jun 2012 09:47:21 +0200
Message-ID: <873967bm2e.fsf@hf.protecting.net> (raw)
References: <4FCEA2DF.3010904@d2.com>
<877gvkc1a6.fsf@hf.protecting.net>
<4FCFC13E.5040503@d2.com>
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$$;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: hari.fuchs@gmail.com
Subject: Re: Can schemas be ordered regarding their creation time ?
In-Reply-To: <873967bm2e.fsf@hf.protecting.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox