Table Description!!

Started by Fariba Noorbakhshalmost 25 years ago5 messagesgeneral

fNoorbakhsh@tecways.com

almost 25 years ago

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

Colin Taylor

Colin_Taylor@portasystems.co.uk

almost 25 years ago

In reply to: Fariba Noorbakhsh (#1)

RE: Table Description!!

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
**********************************************************************

Import Notes

Resolved by subject fallback

omid omoomi

oomoomi@hotmail.com

almost 25 years ago

In reply to: Colin Taylor (#2)

RE: 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@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.

Import Notes

Resolved by subject fallback

Colin Taylor

Colin_Taylor@portasystems.co.uk

almost 25 years ago

In reply to: omid omoomi (#3)

RE: Table Description!!

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 <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.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

Import Notes

Resolved by subject fallback

omid omoomi

oomoomi@hotmail.com

almost 25 years ago

In reply to: Colin Taylor (#4)

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@portasystems.co.uk>
To: 'omid omoomi' <oomoomi@hotmail.com>, 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 <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.

**********************************************************************
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.

Import Notes

Resolved by subject fallback