RE: Table Description!!

From: "omid omoomi" <oomoomi(at)hotmail(dot)com>
To: Colin_Taylor(at)portasystems(dot)co(dot)uk, fNoorbakhsh(at)tecways(dot)com, pgsql-general(at)postgresql(dot)org
Subject: RE: Table Description!!
Date: 2001-07-05 13:22:08
Message-ID: F257igPasSmz6UuEhjJ000018b9@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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.

Browse pgsql-general by date

  From Date Subject
Next Message Nils Zonneveld 2001-07-05 13:26:14 Re: Trigger with current user
Previous Message eddie iannuccelli 2001-07-05 13:21:15 Re: Re: 7.1.2 ERROR: UNIQUE constraint matching given keys for referenced table ......