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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
