Re: Table size

Pavan Deolasee wrote:
> 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 ?

I think what you are referring to is detailed in
http://www.postgresql.org/docs/8.3/interactive/sql-comment.html

The comments are stored in pg_description (and pg_shdescription) but you
should use the comment command instead of manipulating it manually.

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

--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz