[GENERAL] relation create time

Поиск
Список
Период
Сортировка
От Hu, Patricia
Тема [GENERAL] relation create time
Дата
Msg-id A22137031445794A99E795CDDB6BAF589E96BD22@KWAWNEXMBP002.corp.root.nasd.com
обсуждение исходный текст
Ответы Re: [GENERAL] relation create time  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-general

I am trying to find out when a table was created in postgresql. Thought it would be easy (coming from Oracle world), but haven’t had any luck, especially since we are on RDS and can’t peek at the timestamp on the file system. Is this information stored anywhere in the catalog? Or I need to store it myself? Is there any plan to add such meta data information to the catalog as a feature? Thanks a lot!

 

Thanks,

Patricia

 

Confidentiality Notice:: This email, including attachments, may include non-public, proprietary, confidential or legally privileged information. If you are not an intended recipient or an authorized agent of an intended recipient, you are hereby notified that any dissemination, distribution or copying of the information contained in or transmitted with this e-mail is unauthorized and strictly prohibited. If you have received this email in error, please notify the sender by replying to this message and permanently delete this e-mail, its attachments, and any copies of it immediately. You should not retain, copy or use this e-mail or any attachment for any purpose, nor disclose all or any part of the contents to any other person. Thank you.

В списке pgsql-general по дате отправления:

Предыдущее
От: Brian Dunavant
Дата:
Сообщение: Re: [GENERAL] Select from tableA - if not exists then tableB
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [GENERAL] character encoding of the postgres database