Re: Table size
От | Andreas Kretschmer |
---|---|
Тема | Re: Table size |
Дата | |
Msg-id | 20080321164218.GA15035@KanotixBox обсуждение исходный текст |
Ответ на | Re: Table size ("Pavan Deolasee" <pavan.deolasee@gmail.com>) |
Ответы |
Re: Table size
|
Список | pgsql-general |
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°
В списке pgsql-general по дате отправления: