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)





Comments