Re: [GENERAL] Table create time

2017-08-31 Thread Melvin Davidson
On Thu, Aug 31, 2017 at 11:46 AM, Melvin Davidson wrote: > > > On Thu, Aug 31, 2017 at 11:26 AM, Achilleas Mantzios < > ach...@matrix.gatewaynet.com> wrote: > >> On 31/08/2017 18:20, Melvin Davidson wrote: >> >> >you could just create an event trigger looking for CREATE

Re: [GENERAL] Table create time

2017-08-31 Thread Melvin Davidson
On Thu, Aug 31, 2017 at 11:26 AM, Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 31/08/2017 18:20, Melvin Davidson wrote: > > >you could just create an event trigger looking for CREATE TABLE as > filter_value: > > I have tried that. Unfortunately, I have been unable to extract the

Re: [GENERAL] Table create time

2017-08-31 Thread Melvin Davidson
On Thu, Aug 31, 2017 at 11:19 AM, Tom Lane wrote: > Melvin Davidson writes: > > Wolfgang, as David said, a column in pg_class for the creation time of a > > table does not exist. I long ago requested that feature as it is > > in other DB's (Oracle & MS

Re: [GENERAL] Table create time

2017-08-31 Thread Achilleas Mantzios
On 31/08/2017 18:20, Melvin Davidson wrote: >you could just create an event trigger looking for CREATE TABLE as filter_value: I have tried that. Unfortunately, I have been unable to extract the table name from the event because TG_TABLE_NAME is not available during an event trigger, albeit

Re: [GENERAL] Table create time

2017-08-31 Thread Michael Paquier
On Fri, Sep 1, 2017 at 12:20 AM, Melvin Davidson wrote: > >you could just create an event trigger looking for CREATE TABLE as > >filter_value: > > I have tried that. Unfortunately, I have been unable to extract the table > name from the event because TG_TABLE_NAME is not >

Re: [GENERAL] Table create time

2017-08-31 Thread Melvin Davidson
>you could just create an event trigger looking for CREATE TABLE as filter_value: I have tried that. Unfortunately, I have been unable to extract the table name from the event because TG_TABLE_NAME is not available during an event trigger, albeit perhaps I am missing something? That being said, I

Re: [GENERAL] Table create time

2017-08-31 Thread Tom Lane
Melvin Davidson writes: > Wolfgang, as David said, a column in pg_class for the creation time of a > table does not exist. I long ago requested that feature as it is > in other DB's (Oracle & MS SQL Server), but the main reason that it was not > done was that no one was

Re: [GENERAL] Table create time

2017-08-31 Thread Michael Paquier
On Thu, Aug 31, 2017 at 10:21 PM, Melvin Davidson wrote: > Wolfgang, as David said, a column in pg_class for the creation time of a > table does not exist. I long ago requested that feature as it is > in other DB's (Oracle & MS SQL Server), but the main reason that it was

Re: [GENERAL] Table create time

2017-08-31 Thread Achilleas Mantzios
On 31/08/2017 16:12, Achilleas Mantzios wrote: On 31/08/2017 14:03, haman...@t-online.de wrote: On 31/08/2017 09:56, haman...@t-online.de wrote: Hi, is there a way to add a table create (and perhaps schema modify) timestamp to the system? I do occasionally create semi-temporary tables (meant

Re: [GENERAL] Table create time

2017-08-31 Thread Melvin Davidson
On Thu, Aug 31, 2017 at 8:29 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, August 30, 2017, wrote: > >> >> Hi, >> >> is there a way to add a table create (and perhaps schema modify) >> timestamp to the system? >> >> > There is not. You may wish

Re: [GENERAL] Table create time

2017-08-31 Thread Achilleas Mantzios
On 31/08/2017 14:03, haman...@t-online.de wrote: On 31/08/2017 09:56, haman...@t-online.de wrote: Hi, is there a way to add a table create (and perhaps schema modify) timestamp to the system? I do occasionally create semi-temporary tables (meant to live until a problem is solved, i.e. longer

Re: [GENERAL] Table create time

2017-08-31 Thread David G. Johnston
On Wednesday, August 30, 2017, wrote: > > Hi, > > is there a way to add a table create (and perhaps schema modify) timestamp > to the system? > > There is not. You may wish to search the archives for discussions as to why previous requests for this feature have not

Re: [GENERAL] Table create time

2017-08-31 Thread hamann . w
>> On 31/08/2017 09:56, haman...@t-online.de wrote: >> > Hi, >> > >> > is there a way to add a table create (and perhaps schema modify) timestamp >> > to the system? >> > I do occasionally create semi-temporary tables (meant to live until a >> > problem is solved, i.e. longer >> > than a

Re: [GENERAL] Table create time

2017-08-31 Thread Achilleas Mantzios
On 31/08/2017 09:56, haman...@t-online.de wrote: Hi, is there a way to add a table create (and perhaps schema modify) timestamp to the system? I do occasionally create semi-temporary tables (meant to live until a problem is solved, i.e. longer than a session) with conveniently short names.

Re: [GENERAL] Table create time

2017-08-31 Thread Charles Clavadetscher
Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of hamann.w@t- > online.de > Sent: Donnerstag, 31. August 2017 08:56 > To: pgsql-general@postgresql.org > Subject: [GENERAL] Table c

[GENERAL] Table create time

2017-08-31 Thread hamann . w
Hi, is there a way to add a table create (and perhaps schema modify) timestamp to the system? I do occasionally create semi-temporary tables (meant to live until a problem is solved, i.e. longer than a session) with conveniently short names. Also, is there a simple query to identify tables