Re: Can schemas be ordered regarding their creation time ?

From: hari(dot)fuchs(at)gmail(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can schemas be ordered regarding their creation time ?
Date: 2012-06-06 08:06:25
Message-ID: 877gvkc1a6.fsf@hf.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Amador Alvarez <aalvarez(at)d2(dot)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'".

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Manoj Govindassamy 2012-06-06 14:55:15 Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup
Previous Message Manoj Govindassamy 2012-06-06 06:54:30 Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup