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.
A better way is to search for the respective DDL command in postgres log files, if you are logging all DDLs
Payal
On Mon, Jan 2, 2017 at 5:17 AM, Ram DBA <postgresdbas@xxxxxxxxx> wrote:
RamHi team,Do we have a way of figuring out when a table/view is created in the postgres database?Thank you,
ram=# \dv
List of relations
Schema | Name | Type | Owner
--------+--------+------+----------
public | v_test | view | postgres
(1 row)
