Re: Tables creation date and time

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Tables creation date and time
Дата
Msg-id CAFj8pRDK6RRSfYh=85a+w_TBj599h45DAtGDQF130GLWF6d3HQ@mail.gmail.com
обсуждение исходный текст
Ответ на Tables creation date and time  (Prashant Bharucha <prashantbharucha@yahoo.ca>)
Список pgsql-general
Hello

2011/12/7 Prashant Bharucha <prashantbharucha@yahoo.ca>
Hello All

Could you please help me to find out of tables creation date and time in database ?

Thanks
P Bharucha

If you have a PostgreSQL 9.1, you can use a security hooks and write own custom extension, that will store a timestamp to somewhere. This task is possible - I did it, but I can't to publish this work. There are no other ways - you can find a some tips on net based on ctime of datafile - but these values should be invalid.

Regards

Pavel

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

Предыдущее
От: "Marc Mamin"
Дата:
Сообщение: Re: dblink performance
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: dblink performance