Re: [GENERAL][HACKERS] register creation date of table

2011-10-15 Thread Robert Haas
On Fri, Oct 14, 2011 at 6:20 AM, Willy-Bas Loos wrote: > 1. I think that there is no such information in the system tables. is > that correct? Yes. It's been discussed before but some people (particularly, Tom, IIRC) are not convinced that it's useful enough to justify its existence. > 2. i wou

Re: [GENERAL][HACKERS] register creation date of table

2011-10-14 Thread Guillaume Lelarge
On Fri, 2011-10-14 at 15:59 +0200, Willy-Bas Loos wrote: > On Fri, Oct 14, 2011 at 3:38 PM, Guillaume Lelarge > wrote: > > Not sure which pgAdmin release you use, but 1.14 can edit comments on an > > already existing views. > > Of course it supports editting comments on the view itself, but that'

Re: [GENERAL][HACKERS] register creation date of table

2011-10-14 Thread Willy-Bas Loos
On Fri, Oct 14, 2011 at 3:38 PM, Guillaume Lelarge wrote: > Not sure which pgAdmin release you use, but 1.14 can edit comments on an > already existing views. Of course it supports editting comments on the view itself, but that's not what i mean. I have a view that shows the comments on all the t

Re: [GENERAL][HACKERS] register creation date of table

2011-10-14 Thread Guillaume Lelarge
On Fri, 2011-10-14 at 14:55 +0200, Willy-Bas Loos wrote: > On Fri, Oct 14, 2011 at 2:51 PM, Guillaume Lelarge > wrote: > >> When you edit the description in the table (or the view, but no > >> support in pgAdmin), the comment in the system tables is updated also. > > > I'm not sure I understand y

Re: [GENERAL][HACKERS] register creation date of table

2011-10-14 Thread Willy-Bas Loos
On Fri, Oct 14, 2011 at 2:51 PM, Guillaume Lelarge wrote: >> When you edit the description in the table (or the view, but no >> support in pgAdmin), the comment in the system tables is updated also. > I'm not sure I understand your comment: "no support in pgAdmin". No > support for what? Editabl

Re: [GENERAL][HACKERS] register creation date of table

2011-10-14 Thread Guillaume Lelarge
Hi, On Fri, 2011-10-14 at 12:20 +0200, Willy-Bas Loos wrote: > [...] > We have several users working on a 8.4 database, using it as a > back-end for several related apps and transfering data to and from it. > The database tends to get a bit messy, so i've made a little table to > provide an overvi

[GENERAL][HACKERS] register creation date of table

2011-10-14 Thread Willy-Bas Loos
Hi, We have several users working on a 8.4 database, using it as a back-end for several related apps and transfering data to and from it. The database tends to get a bit messy, so i've made a little table to provide an overview. This table is truncated and refilled daily, it shows all tables and v