Re: Table/View creation time

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

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> 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
>