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