From: Amador Alvarez <aalvarez@d2.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Can schemas be ordered regarding their creation time ?
Date: Tue, 05 Jun 2012 17:58:07 -0700
Message-ID: <4FCEAB1F.8090006@d2.com> (raw)
In-Reply-To: <4120.1338943414@sss.pgh.pa.us>
References: <4FCEA2DF.3010904@d2.com>
<4120.1338943414@sss.pgh.pa.us>
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@d2.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aalvarez@d2.com, tgl@sss.pgh.pa.us
Subject: Re: Can schemas be ordered regarding their creation time ?
In-Reply-To: <4FCEAB1F.8090006@d2.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox