Thread: [ADMIN] Table/View creation time
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)
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@gmail.com> 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)
Dear Payal,
You can find out time when any database objects are created By using Concepts of Event Trigger
Please refer this link
Thanks
Avinash Patil
On Tue, Jan 3, 2017 at 8:53 PM, Payal Singh <payal@omniti.com> 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 DDLsPayalOn Mon, Jan 2, 2017 at 5:17 AM, Ram DBA <postgresdbas@gmail.com> 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)
Thanks ,
Avinash Patil.
On 03/01/2017 17:23, Payal Singh wrote:
Modern Linux'es do not support exposing creation time. EXT4 stores this though.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 DDLsPayalOn Mon, Jan 2, 2017 at 5:17 AM, Ram DBA <postgresdbas@gmail.com> 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)
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt