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
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
Hi
Indeed, the SQL COMMENT clause is on our list of requested features.
regards, Martin
On 02/04/15 14:36, Brian Hood wrote:
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 mailto: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 <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Brian Hood
-
Martin Kersten
-
Puthick Hok