Hi Puthick,

I actually can't see in table elements documentation that there is a way to add comments to your fields.

Regards,

Brian Hood

On Apr 2, 2015 5:57 AM, "Puthick Hok" <hputhick@gmail.com> wrote:
Hi,

I am working on developing a database web service layer for an open
source plant/animal breeding platform. So far I rely on having field
comment in CREATE TABLE SQL statement like

CREATE TABLE "extract" (  "ExtractId" int NOT NULL auto_increment
COMMENT 'Id of the DNA extract') ;

for the online help. So far, we use MySQL for general storage,
postgres for GIS and environment data storage. Both MySQL and Postgres
support field comment in slightly different means.

We are going to switch to MonetDB as our improved marker data storage.

I have tested that the previous CREATE TABLE SQL would not work in MonetDB.

Will MonetDB support this feature in the future?

Regards,
Puthick
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list