Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group