Postgres Pro
Downloads
Home   >   mailing lists

Re: Can schemas be ordered regarding their creation time ? - Mailing list pgsql-admin

From hari.fuchs@gmail.com
Subject Re: Can schemas be ordered regarding their creation time ?
Date
Msg-id 877gvkc1a6.fsf@hf.protecting.net
Whole thread Raw
In response to Can schemas be ordered regarding their creation time ?  (Amador Alvarez <aalvarez@d2.com>)
Responses Re: Can schemas be ordered regarding their creation time ?
List pgsql-admin
Tree view 
Amador Alvarez <aalvarez@d2.com> writes:

> Hi there,
> 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.

You could attach the creation date to the schema name or use
"COMMENT ON SCHEMA x IS 'y'".

pgsql-admin by date:

Previous
From: shuaixf
Date:
Subject: Re: Could the unlogged table of postgresql be used as session?
Next
From: Manoj Govindassamy
Date:
Subject: Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup