Re: Table size - Mailing list pgsql-general

From Shane Ambler
Subject Re: Table size
Date
Msg-id 47E3E1BF.5030305@Sheeky.Biz
Whole thread Raw
In response to Re: Table size  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
List pgsql-general
Pavan Deolasee wrote:
> 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 ?

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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: MySQL to Postgres question
Next
From: Erik Jones
Date:
Subject: Re: Table size