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

Re: Can schemas be ordered regarding their creation time ?

From: Amador Alvarez <aalvarez(at)d2(dot)com>
To: pgsql-admin(at)postgresql(dot)org, hari(dot)fuchs(at)gmail(dot)com
Subject: Re: Can schemas be ordered regarding their creation time ?
Date: 2012-06-07 18:29:03
Message-ID: 4FD0F2EF.4070302@d2.com (view raw or flat)
Thread:
Lists: pgsql-admin
Thanks a lot Hari,
very resourceful, you have been very helpful.

cheers,
A.A.

On 06/07/2012 12:47 AM, hari(dot)fuchs(at)gmail(dot)com wrote:
> 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

pgsql-admin by date

Next:From: Magnus HaganderDate: 2012-06-07 19:40:45
Subject: Re: pg_basebackup blocking all queries with horrible performance
Previous:From: Lonni J FriedmanDate: 2012-06-07 18:04:53
Subject: Re: pg_basebackup blocking all queries with horrible performance

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