RE: Table Description!! - Mailing list pgsql-general

From omid omoomi
Subject RE: Table Description!!
Date
Msg-id F257igPasSmz6UuEhjJ000018b9@hotmail.com
Whole thread Raw
In response to Table Description!!  (Fariba Noorbakhsh <fNoorbakhsh@tecways.com>)
List pgsql-general
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@portasystems.co.uk>
>To: "'Fariba Noorbakhsh'" <fNoorbakhsh@tecways.com>,
>pgsql-general@postgresql.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@tecways.com]
> > Sent: Wednesday, 04 July 2001 14:54
> > To: pgsql-general@postgresql.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@portasystems.co.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.


pgsql-general by date:

Previous
From: Nicolas Kowalski
Date:
Subject: Trigger with current user
Next
From: Colin Taylor
Date:
Subject: RE: Table Description!!