Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Table/View creation time - Mailing list pgsql-admin

From Payal Singh
Subject Re: [ADMIN] Table/View creation time
Date
Msg-id CANUg7LDK06QNfkxAXGT+EhFV=GFu5NdY8bHAqYLi0MHJY2NNGg@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Table/View creation time  (Ram DBA <postgresdbas@gmail.com>)
Responses Re: [ADMIN] Table/View creation time
Re: [ADMIN] Table/View creation time
List pgsql-admin
Tree view
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@gmail.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

pgsql-admin by date:

Previous
From: Ram DBA
Date:
Subject: [ADMIN] Table/View creation time
Next
From: Avinash Patil
Date:
Subject: Re: [ADMIN] Table/View creation time