Pavan Deolasee <pavan.deolasee@gmail.com> schrieb:
> On Fri, Mar 21, 2008 at 3:03 PM, lak <lakindia89@gmail.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°