Re: [GENERAL] When to use COMMENT vs --

2016-12-09 Thread Merlin Moncure
On Wed, Dec 7, 2016 at 9:57 AM, Rich Shepard wrote: > I have used '-- ' to enter comments about tables or columns and am curious > about the value of storing comments in tables using the COMMENT key word. > When is the latter more appropriate than the former? Main advantage of COMMENT is that t

Re: [GENERAL] When to use COMMENT vs --

2016-12-08 Thread Rich Shepard
On Thu, 8 Dec 2016, Charles Clavadetscher wrote: IMHO the fact mentioned by Chris Travers that comments on objects included in the database can be used by tools to generate the documentation is probably the most important (besides their being persisted). Charles, Chris' contribution was the

Re: [GENERAL] When to use COMMENT vs --

2016-12-07 Thread Charles Clavadetscher
Hi Rich > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Travers > Sent: Mittwoch, 7. Dezember 2016 17:12 > To: Postgres General > Subject: Re: [GENERAL] When to use COMMENT vs -- > >

Re: [GENERAL] When to use COMMENT vs --

2016-12-07 Thread Chris Travers
On Dec 7, 2016 5:07 PM, "Karsten Hilbert" wrote: > > On Wed, Dec 07, 2016 at 07:57:54AM -0800, Rich Shepard wrote: > > > I have used '-- ' to enter comments about tables or columns and am curious > > about the value of storing comments in tables using the COMMENT key word. > > When is the latter

Re: [GENERAL] When to use COMMENT vs --

2016-12-07 Thread John McKown
On Wed, Dec 7, 2016 at 9:57 AM, Rich Shepard wrote: > I have used '-- ' to enter comments about tables or columns and am > curious > about the value of storing comments in tables using the COMMENT key word. > When is the latter more appropriate than the former? > > TIA, > > Rich ​-- is a comm

Re: [GENERAL] When to use COMMENT vs --

2016-12-07 Thread Karsten Hilbert
On Wed, Dec 07, 2016 at 07:57:54AM -0800, Rich Shepard wrote: > I have used '-- ' to enter comments about tables or columns and am curious > about the value of storing comments in tables using the COMMENT key word. > When is the latter more appropriate than the former? "--" only means "comment"

Re: [GENERAL] When to use COMMENT vs --

2016-12-07 Thread Pavel Stehule
2016-12-07 16:57 GMT+01:00 Rich Shepard : > I have used '-- ' to enter comments about tables or columns and am > curious > about the value of storing comments in tables using the COMMENT key word. > When is the latter more appropriate than the former? > Description entered with COMMENT statemen

[GENERAL] When to use COMMENT vs --

2016-12-07 Thread Rich Shepard
I have used '-- ' to enter comments about tables or columns and am curious about the value of storing comments in tables using the COMMENT key word. When is the latter more appropriate than the former? TIA, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make ch