Re: [ADMIN] Can schemas be ordered regarding their creation time ?

2012-06-05 Thread Tom Lane
Amador Alvarez aalva...@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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


Re: [ADMIN] Can schemas be ordered regarding their creation time ?

2012-06-05 Thread Amador Alvarez

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 Alvarezaalva...@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


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


Re: [ADMIN] Could the unlogged table of postgresql be used as session?

2012-06-05 Thread shuaixf
which friend knows?

--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Could-the-unlogged-table-of-postgresql-be-used-as-session-tp5710923p5711376.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin