Re: Table size

Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> schrieb:

> On Fri, Mar 21, 2008 at 3:03 PM, lak <lakindia89(at)gmail(dot)com> wrote:
> > I have two questions.
> > How can I enter comments into a table? Where the comments are stored?
> >
>
> What do you mean by comments in a table ?

Comments on a table or a column or on other objects.

Comments on objects can set by:

comment on ... is 'comment';

Please read within psql the output from '\h comment' to learn more.
Comments are stored in pg_description:
http://www.postgresql.org/docs/current/interactive/catalog-pg-description.html

>
> > In psql How can I know the size of a single table?
> >
>
> Select pg_relation_size('mytable');

More about that:
http://andreas.scherbaum.la/blog/archives/282-table-size,-database-size.html

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°