Re: [ADMIN] Table/View creation time

Поиск
Список
Период
Сортировка
От Payal Singh
Тема Re: [ADMIN] Table/View creation time
Дата
Msg-id CANUg7LDK06QNfkxAXGT+EhFV=GFu5NdY8bHAqYLi0MHJY2NNGg@mail.gmail.com
обсуждение исходный текст
Ответ на [ADMIN] Table/View creation time  (Ram DBA <postgresdbas@gmail.com>)
Ответы Re: [ADMIN] Table/View creation time  (Avinash Patil <avinashpatil2020@gmail.com>)
Re: [ADMIN] Table/View creation time  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Ram DBA
Дата:
Сообщение: [ADMIN] Table/View creation time
Следующее
От: Avinash Patil
Дата:
Сообщение: Re: [ADMIN] Table/View creation time