Re: Can schemas be ordered regarding their creation time ?

From: Amador Alvarez <aalvarez(at)d2(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can schemas be ordered regarding their creation time ?
Date: 2012-06-06 00:58:07
Message-ID: 4FCEAB1F.8090006@d2.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks Tom,
I will figure out then how to add a newly created schema to the
schema-list to be backed up (dumped) but not directly as i expected.

Cheers,
A.A.

On 06/05/2012 05:43 PM, Tom Lane wrote:
> Amador Alvarez<aalvarez(at)d2(dot)com> writes:
>> I would like to know if it is possible to get the date when the
>> different schemas were created, as I want to write an script to dump
>> only the latest schemas, the latest month created schemas for instance.
> No, sorry, Postgres does not track creation time of database objects.
>
> regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message shuaixf 2012-06-06 05:13:20 Re: Could the unlogged table of postgresql be used as session?
Previous Message Tom Lane 2012-06-06 00:43:34 Re: Can schemas be ordered regarding their creation time ?