From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [HACKERS] register creation date of table |
Date: | 2011-10-14 12:51:31 |
Message-ID: | 1318596691.2127.39.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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 overview.
> This table is truncated and refilled daily, it shows all tables and
> views in the database and :
> * the owner
> * number of records (estimation)
> * it's size on disk
> * the description
>
> There's a view on the table that shows the size as pg_size_pretty
> 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 attatched my code, hope some people find it handy, sorry for the
> names and comments being in dutch.
>
I'm not sure I understand your comment: "no support in pgAdmin". No
support for what?
> Now, i would like to improve this thing and add a creation date for the table.
> I have some questions about that.
> 1. I think that there is no such information in the system tables. is
> that correct?
Yes.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2011-10-14 12:55:42 | Re: [HACKERS] register creation date of table |
Previous Message | Alexander Farber | 2011-10-14 11:58:46 | Re: Slow query: select * order by XXX desc offset 10 limit 10 |
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2011-10-14 12:55:42 | Re: [HACKERS] register creation date of table |
Previous Message | Robert Haas | 2011-10-14 12:36:47 | Re: about EDITOR_LINENUMBER_SWITCH |