From oomoomi@hotmail.com Thu Jun 4 14:00:25 2026 Received: from hotmail.com (f194.law14.hotmail.com [64.4.21.194]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f65DmEa97840 for ; Thu, 5 Jul 2001 09:48:14 -0400 (EDT) (envelope-from oomoomi@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 5 Jul 2001 06:48:09 -0700 Received: from 213.29.16.6 by lw14fd.law14.hotmail.msn.com with HTTP; Thu, 05 Jul 2001 13:48:00 GMT X-Originating-IP: [213.29.16.6] From: "omid omoomi" To: Colin_Taylor@portasystems.co.uk, pgsql-general@postgresql.org Subject: RE: Table Description!! Date: Thu, 05 Jul 2001 13:48:00 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 05 Jul 2001 13:48:09.0578 (UTC) FILETIME=[205564A0:01C10559] X-Archive-Number: 200107/116 X-Sequence-Number: 12031 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 >To: 'omid omoomi' , pgsql-general@postgresql.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@hotmail.com] > > Sent: Thursday, 05 July 2001 14:22 > > To: Colin_Taylor@portasystems.co.uk; fNoorbakhsh@tecways.com; > > pgsql-general@postgresql.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 > > >To: "'Fariba Noorbakhsh'" , > > >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 IS ''; > > > > > >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. > > >********************************************************************** >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 >********************************************************************** _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. From oomoomi@hotmail.com Thu Jun 4 14:00:25 2026 Received: from hotmail.com (f257.law14.hotmail.com [64.4.20.132]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f65DMCa85259 for ; Thu, 5 Jul 2001 09:22:13 -0400 (EDT) (envelope-from oomoomi@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 5 Jul 2001 06:22:08 -0700 Received: from 213.29.16.6 by lw14fd.law14.hotmail.msn.com with HTTP; Thu, 05 Jul 2001 13:22:08 GMT X-Originating-IP: [213.29.16.6] From: "omid omoomi" To: Colin_Taylor@portasystems.co.uk, fNoorbakhsh@tecways.com, pgsql-general@postgresql.org Subject: RE: Table Description!! Date: Thu, 05 Jul 2001 13:22:08 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 05 Jul 2001 13:22:08.0539 (UTC) FILETIME=[7DE1BEB0:01C10555] X-Archive-Number: 200107/113 X-Sequence-Number: 12028 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 >To: "'Fariba Noorbakhsh'" , >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
IS ''; > >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. From fNoorbakhsh@tecways.com Thu Jun 4 14:00:21 2026 Received: from pollux.tecways.com (pollux.ccs-munich.de [212.222.84.180]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f64Dkka08481 for ; Wed, 4 Jul 2001 09:46:46 -0400 (EDT) (envelope-from fNoorbakhsh@tecways.com) Received: from zeus.tecways.com (zeus.ccs-munich.de [172.21.2.4]) by pollux.tecways.com (Postfix) with ESMTP id 3E3F58801B for ; Wed, 4 Jul 2001 13:47:31 +0000 (/etc/localtime) Received: from ccs-munich.de (berlin.ccs-munich.de [172.21.5.242]) by zeus.tecways.com (Postfix on SuSE Linux 7.0 (i386)) with ESMTP id 58A8D6D99B for ; Wed, 4 Jul 2001 12:47:43 +0000 (/etc/localtime) Message-ID: <3B431FE3.85E32EE7@ccs-munich.de> Date: Wed, 04 Jul 2001 15:53:39 +0200 From: Fariba Noorbakhsh X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Table Description!! Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/74 X-Sequence-Number: 11985 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 From Colin_Taylor@portasystems.co.uk Thu Jun 4 14:00:24 2026 Received: from finch-post-11.mail.demon.net (finch-post-11.mail.demon.net [194.217.242.39]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6579Ea73873 for ; Thu, 5 Jul 2001 03:09:19 -0400 (EDT) (envelope-from Colin_Taylor@portasystems.co.uk) Received: from mailgate.portasystems.co.uk ([194.217.118.115] helo=sweep.portasystems.co.uk) by finch-post-11.mail.demon.net with esmtp (Exim 2.12 #1) id 15I3GC-0006gz-0B for pgsql-general@postgresql.org; Thu, 5 Jul 2001 07:09:12 +0000 Received: from server2.portasystems.co.uk (unverified) by sweep.portasystems.co.uk (Content Technologies SMTPRS 4.1.5) with ESMTP id ; Thu, 5 Jul 2001 08:09:00 +0100 Received: by SERVER2 with Internet Mail Service (5.5.2653.19) id <2VQWWJZV>; Thu, 5 Jul 2001 08:08:59 +0100 Message-ID: <4BDEC5E174E9D411B5BD00AA00AD07B009B3DF@SERVER3> From: Colin Taylor To: "'Fariba Noorbakhsh'" , pgsql-general@postgresql.org Subject: RE: Table Description!! Date: Thu, 5 Jul 2001 08:08:55 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200107/104 X-Sequence-Number: 12019 You could use the "COMMENT" command. Something like: COMMENT ON TABLE
IS ''; 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 ********************************************************************** From Colin_Taylor@portasystems.co.uk Thu Jun 4 14:00:24 2026 Received: from tele-post-20.mail.demon.net (tele-post-20.mail.demon.net [194.217.242.20]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f65DUCa88971 for ; Thu, 5 Jul 2001 09:30:12 -0400 (EDT) (envelope-from Colin_Taylor@portasystems.co.uk) Received: from mailgate.portasystems.co.uk ([194.217.118.115] helo=sweep.portasystems.co.uk) by tele-post-20.mail.demon.net with esmtp (Exim 2.12 #2) id 15I9Cq-000GKd-0K for pgsql-general@postgresql.org; Thu, 5 Jul 2001 13:30:08 +0000 Received: from server2.portasystems.co.uk (unverified) by sweep.portasystems.co.uk (Content Technologies SMTPRS 4.1.5) with ESMTP id ; Thu, 5 Jul 2001 14:29:54 +0100 Received: by SERVER2 with Internet Mail Service (5.5.2653.19) id <2VQWWKAA>; Thu, 5 Jul 2001 14:29:53 +0100 Message-ID: <4BDEC5E174E9D411B5BD00AA00AD07B009B3EB@SERVER3> From: Colin Taylor To: "'omid omoomi'" , pgsql-general@postgresql.org Subject: RE: Table Description!! Date: Thu, 5 Jul 2001 14:29:43 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200107/114 X-Sequence-Number: 12029 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@hotmail.com] > Sent: Thursday, 05 July 2001 14:22 > To: Colin_Taylor@portasystems.co.uk; fNoorbakhsh@tecways.com; > pgsql-general@postgresql.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 > >To: "'Fariba Noorbakhsh'" , > >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
IS ''; > > > >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. ********************************************************************** 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 **********************************************************************