how to check schema creation date in greenplum
Note: Checking schema creation time
select pgn.oid,pgn.nspname,pslo.staactionname,pslo.stasubtype,pslo.stausename as createdby,statime as cretedate from pg_namespace pgn,pg_stat_last_operation pslo where pgn.nspname like '%<schenmanamein LOWER CASE>%' and pslo.staactionname='CREATE' and pgn.oid=pslo.objid;
For Example
select pgn.oid,pgn.nspname,pslo.staactionname,pslo.stasubtype,pslo.stausename as createdby,statime as cretedate from pg_namespace pgn,pg_stat_last_operation pslo where pgn.nspname like '%dbaref %' and pslo.staactionname='CREATE' and pgn.oid=pslo.objid;
oid | nspname | staactionname | stasubtype | createdby | cretedate
---------+---------+---------------+------------+-----------+-------------------------------
1193065 | dbref_1 | CREATE | SCHEMA | gpadmin | 2015-01-28 14:02:22.040402-05
590737 | dbaref | CREATE | SCHEMA | gpadmin | 2014-12-03 08:52:28.172581-05
590738 | dbaref_2 | CREATE | SCHEMA | gpadmin | 2014-12-03 08:52:37.728587-05
590739 | dbaref_3 | CREATE | SCHEMA | gpadmin | 2014-12-03 08:52:47.659598-05
(4 rows)