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.

Thanks in advance,
A.A.

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

Amador Alvarez <aalvarez (AT) d2 (DOT) com> writes:
No, sorry, Postgres does not track creation time of database objects.

regards, tom lane

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

Amador Alvarez <aalvarez (AT) d2 (DOT) com> writes:

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


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

Amador Alvarez <aalvarez (AT) d2 (DOT) com> writes:

You could use PL/pgSQL's "EXECUTE" for that:

DO $$BEGIN
EXECUTE 'COMMENT ON SCHEMA myschema IS ''Created ' ||
current_timestamp || '''';
END$$;


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