RE: Table Description!!

Hmmm... My pg version was 6.5.2 and seems that it doesn't support it.
I just check it out on 7.1... and "comment" was OK. ;)
thanks
Omid

>From: Colin Taylor <Colin_Taylor(at)portasystems(dot)co(dot)uk>
>To: 'omid omoomi' <oomoomi(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
>Subject: RE: [GENERAL] Table Description!!
>Date: Thu, 5 Jul 2001 14:29:43 +0100
>
>Check out http://www.postgresql.org/idocs/index.php?sql-comment.html.
>I got my knowledge from the PostgreSQL: Introduction and Concepts book.
>HTH,
>Colin
>
> > -----Original Message-----
> > From: omid omoomi [mailto:oomoomi(at)hotmail(dot)com]
> > Sent: Thursday, 05 July 2001 14:22
> > To: Colin_Taylor(at)portasystems(dot)co(dot)uk; fNoorbakhsh(at)tecways(dot)com;
> > pgsql-general(at)postgresql(dot)org
> > Subject: RE: [GENERAL] Table Description!!
> >
> >
> > Hi,
> > I couldn't find such a thing.
> > May be better if having a copy from pg_tables and add a
> > description column
> > to that:
> >
> > Create table foo as Select * from pg_tables;
> > Alter table foo add col descript text ;
> >
> > HTH
> > Omid
> >
> > >From: Colin Taylor <Colin_Taylor(at)portasystems(dot)co(dot)uk>
> > >To: "'Fariba Noorbakhsh'" <fNoorbakhsh(at)tecways(dot)com>,
> > >pgsql-general(at)postgresql(dot)org
> > >Subject: RE: [GENERAL] Table Description!!
> > >Date: Thu, 5 Jul 2001 08:08:55 +0100
> > >
> > >You could use the "COMMENT" command.
> > >Something like:
> > >COMMENT ON TABLE <table name> IS '<comment>';
> > >
> > >HTH,
> > >Colin
> > >
> > > > -----Original Message-----
> > > > From: Fariba Noorbakhsh [mailto:fNoorbakhsh(at)tecways(dot)com]
> > > > Sent: Wednesday, 04 July 2001 14:54
> > > > To: pgsql-general(at)postgresql(dot)org
> > > > Subject: [GENERAL] Table Description!!
> > > >
> > > >
> > > > Hi everybody,
> > > >
> > > > I want to have a description for tables in my DB(Postgresql DB).
> > > > Is there any way to put description of tables in Postgresql
> > > > DB or not?!
> > > >
> > > > Thanks in Advance,
> > > > Fariba
> > > >
> > > >
> > > > ---------------------------(end of
> > > > broadcast)---------------------------
> > > > TIP 5: Have you checked our extensive FAQ?
> > > >
> > > > http://www.postgresql.org/users-lounge/docs/faq.html
> > > >
> > >
> > >
> > >*************************************************************
> > *********
> > >This email and any files transmitted with it are confidential and
> > >intended solely for the use of the individual or entity to whom they
> > >are addressed. If you have received this email in error please notify
> > >the system manager. postmaster(at)portasystems(dot)co(dot)uk
> > >
> > >This footnote also confirms that this email message has been swept by
> > >MIMEsweeper for the presence of computer viruses.
> > >
> > >www.mimesweeper.com
> > >*************************************************************
> > *********
> > >
> > >---------------------------(end of
> > broadcast)---------------------------
> > >TIP 5: Have you checked our extensive FAQ?
> > >
> > >http://www.postgresql.org/users-lounge/docs/faq.html
> >
> > ______________________________________________________________
> > ___________
> > Get Your Private, Free E-mail from MSN Hotmail at
>http://www.hotmail.com.
>
>
>**********************************************************************
>This email and any files transmitted with it are confidential and
>intended solely for the use of the individual or entity to whom they
>are addressed. If you have received this email in error please notify
>the system manager. postmaster(at)portasystems(dot)co(dot)uk
>
>This footnote also confirms that this email message has been swept by
>MIMEsweeper for the presence of computer viruses.
>
>www.mimesweeper.com
>**********************************************************************

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.