Re: Table/View creation time

[Avinash Patil <avinashpatil2020@xxxxxxxxx>]

Dear Payal,

You can find out time when any database objects are created By using Concepts of Event Trigger

Please refer this link 

http://paquier.xyz/postgresql-2/postgres-9-3-feature-highlight-event-triggers/

Thanks

Avinash Patil

On Tue, Jan 3, 2017 at 8:53 PM, Payal Singh <payal@xxxxxxxxxx> 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.

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

--

Thanks ,

Avinash Patil.