Re: Can schemas be ordered regarding their creation time ?

From: hari(dot)fuchs(at)gmail(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can schemas be ordered regarding their creation time ?
Date: 2012-06-07 07:47:21
Message-ID: 873967bm2e.fsf@hf.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Amador Alvarez <aalvarez(at)d2(dot)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$$;

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ROMAIN, ERICKA W CTR DISA PEO-MA 2012-06-07 15:12:38 How To Change Password Hash Algorithm From MD5 to SHA-256
Previous Message Richard Albright 2012-06-06 21:03:50 Re: Hstore vs simple K:V