How to check table creation time in Greenplum

Post date: Sep 19, 2014 3:4:49 PM

sachi=# create table sachi3(abc text);

NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'abc' as the Greenplum Database data distribution key for this table.

HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.

CREATE TABLE

sachi=# select * from pg_stat_last_operation where objid = 'sachi3' ::regclass order by statime;

---------+-------+---------------+----------+------------+------------+-------------------------------

1259 | 52386 | CREATE | 10 | gpadmin | TABLE | 2014-09-19 10:54:58.753318-04

(1 row)