Re: Table/View creation time

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(at)gmail(dot)com <mailto:postgresdbas(at)gmail(dot)com>> 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