Greenplum : Object Creation Date

Asked Jul 10 '15 at 17:14

Active Jul 10 '15 at 17:14

Viewed 569 times

I have used pg_stat_operations to know when a table or view is created or altered,

I want to know when a function or sequence is created or modified. (Function list is availed at pg_proc and information_schema.routines but there is no option for creation or modification date)

Is there any way to find it out???

asked Jul 10 '15 at 17:14

Gurupreet Singh Bhatia

1

PostgreSQL doesn't keep track of object creation timestamps. Unless Greenplum added them, there's no such facility. – Craig Ringer Jul 11 '15 at 07:03
The only option is to grep through pg_log – 0x0FFF Aug 06 '15 at 08:05

Greenplum : Object Creation Date

0 Answers0