Re: Can schemas be ordered regarding their creation time ?

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

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Amador Alvarez 2012-06-06 00:58:07 Re: Can schemas be ordered regarding their creation time ?
Previous Message Amador Alvarez 2012-06-06 00:22:55 Can schemas be ordered regarding their creation time ?