Feature request - Include comments in SQL export

Ask the Community
1

Hi, I’ve just found dbdiagram, and so far I’m loving it. Nice work! :slight_smile:

Would it be possible to include the comments when exporting a diagram to SQL? It could work like this:

// this is just a comment
table foo { // this is a table comment
  id int [pk] // and this is a column comment
}

The exported SQL would be something like this for PostgreSQL:

-- this is just a comment
create table foo (id int primary key);
comment on table foo is 'this is a table comment';
comment on column foo.id is 'this is a column comment';

And like this for MySQL:

-- this is just a comment
create table foo (
  id int primary key comment="this is a column comment"
) comment="this is a table comment";

Or if you want to keep it simple, just export everything as -- code comments, it would still be useful.

2

Hi thanks for for suggestion! Actually we just released this (haven’t updated our docs with it). Can you try the following, and then hover through the price field.

Table products {
  id int [pk]
  name varchar
  merchant_id int [not null]
  price int [note: "This is how much being listed"]
  status varchar
  created_at varchar
}
1 Like
3

Awesome!!! It works great both in the diagram and in the exported SQL :smiley:

Is there something similar for tables?

1 Like
4

Thanks mate, not at the moment no. But will update you guys when it comes.

5

This appears now to be broken for PostgreSQL .

The Comment statement is completely missing from PostgreSQL Export of the following:

Table listing_revenue_data1 {
  id int [pk, increment]
  include_in_listing bit [note: "test"]
 }
6

Hah I am having the opposite issue - I want to optionally disable the note to COMMENT behaviour when exporting to PostgreSQL

1 Like