Em sábado, 2 de julho de 2016, David G. Johnston <david.g.johns...@gmail.com> escreveu:
> On Sat, Jul 2, 2016 at 12:55 PM, Marko Tiikkaja <ma...@joh.to > <javascript:_e(%7B%7D,'cvml','ma...@joh.to');>> wrote: > >> >> What I would prefer is something like this: >> >> CREATE TABLE foo( >> f1 int NOT NULL COMMENT >> 'the first field', >> f2 int NOT NULL COMMENT >> 'the second field', >> ... >> ); >> >> which would ensure the comments are both next to the field definition >> they're documenting and that they make it all the way to the database. I >> looked into the biggest products, and MySQL supports this syntax. I >> couldn't find any similar syntax in any other product. >> >> > +1 for the idea - though restricting it to columns would not be ideal. > > > CREATE TABLE name > COMMENT IS > 'Table Comment Here' > ( > col1 serial COMMENT IS 'Place comment here' > ); > > And what about the other CREATE statements? IMHO if we follow this path then we should add COMMENT to all CREATE statements and perhaps also to ALTER. Of course in a set of small patches to make the reviewers life easier. Regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Timbira: http://www.timbira.com.br >> Blog: http://fabriziomello.github.io >> Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello >> Github: http://github.com/fabriziomello
