Re: Table size

Pavan Deolasee  schrieb:

> On Fri, Mar 21, 2008 at 3:03 PM, lak  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°