public inbox for [email protected]
help / color / mirror / Atom feedRE: Table Description!!
5+ messages / 3 participants
[nested] [flat]
* RE: Table Description!!
@ 1970-01-01 00:00 omid omoomi <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: omid omoomi @ 1970-01-01 00:00 UTC (permalink / raw)
To: [email protected]; [email protected]; 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 <[email protected]>
>To: "'Fariba Noorbakhsh'" <[email protected]>,
>[email protected]
>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:[email protected]]
> > Sent: Wednesday, 04 July 2001 14:54
> > To: [email protected]
> > 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. [email protected]
>
>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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Table Description!!
@ 1970-01-01 00:00 omid omoomi <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: omid omoomi @ 1970-01-01 00:00 UTC (permalink / raw)
To: [email protected]; pgsql-general
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 <[email protected]>
>To: 'omid omoomi' <[email protected]>, [email protected]
>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:[email protected]]
> > Sent: Thursday, 05 July 2001 14:22
> > To: [email protected]; [email protected];
> > [email protected]
> > 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 <[email protected]>
> > >To: "'Fariba Noorbakhsh'" <[email protected]>,
> > >[email protected]
> > >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:[email protected]]
> > > > Sent: Wednesday, 04 July 2001 14:54
> > > > To: [email protected]
> > > > 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. [email protected]
> > >
> > >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. [email protected]
>
>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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Table Description!!
@ 2001-07-04 13:53 Fariba Noorbakhsh <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: Fariba Noorbakhsh @ 2001-07-04 13:53 UTC (permalink / raw)
To: pgsql-general
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Table Description!!
@ 2001-07-05 07:08 Colin Taylor <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: Colin Taylor @ 2001-07-05 07:08 UTC (permalink / raw)
To: 'Fariba Noorbakhsh' <[email protected]>; pgsql-general
You could use the "COMMENT" command.
Something like:
COMMENT ON TABLE <table name> IS '<comment>';
HTH,
Colin
> -----Original Message-----
> From: Fariba Noorbakhsh [mailto:[email protected]]
> Sent: Wednesday, 04 July 2001 14:54
> To: [email protected]
> 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. [email protected]
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Table Description!!
@ 2001-07-05 13:29 Colin Taylor <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: Colin Taylor @ 2001-07-05 13:29 UTC (permalink / raw)
To: 'omid omoomi' <[email protected]>; pgsql-general
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:[email protected]]
> Sent: Thursday, 05 July 2001 14:22
> To: [email protected]; [email protected];
> [email protected]
> 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 <[email protected]>
> >To: "'Fariba Noorbakhsh'" <[email protected]>,
> >[email protected]
> >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:[email protected]]
> > > Sent: Wednesday, 04 July 2001 14:54
> > > To: [email protected]
> > > 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. [email protected]
> >
> >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. [email protected]
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-07-05 13:29 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1970-01-01 00:00 RE: Table Description!! omid omoomi <[email protected]>
1970-01-01 00:00 RE: Table Description!! omid omoomi <[email protected]>
2001-07-04 13:53 Table Description!! Fariba Noorbakhsh <[email protected]>
2001-07-05 07:08 RE: Table Description!! Colin Taylor <[email protected]>
2001-07-05 13:29 RE: Table Description!! Colin Taylor <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox