Re: Table/View creation time

[Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx>]

On 03/01/2017 17:23, Payal Singh wrote:

You might be able to get some useful info by running stat on $PGDATA/base/<table's relid> (for instance when the file was created). Don't think this is applicable for a view though.

Modern Linux'es do not support exposing creation time. EXT4 stores this though.

A better way is to search for the respective DDL command in postgres log files, if you are logging all DDLs

Payal

Payal Singh,
Database Administrator,

OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253

On Mon, Jan 2, 2017 at 5:17 AM, Ram DBA <postgresdbas@xxxxxxxxx> wrote:

Hi team,

Do we have a way of figuring out when a table/view is created in the postgres database?

ram=# \dv
         List of relations
 Schema |  Name  | Type |  Owner
--------+--------+------+----------
 public | v_test | view | postgres
(1 row)

Thank you,

Ram

-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt