Set PostgreSQL comments on tables and columns

[smigalni]

Hi,
How to write Comments on Columns using dotnet core Web API with Entity Framework core with PostgreSQL.
I am using dotnet core with Npgsql v3.1.9 and Npgsql.EntityFrameworkCore.PostgreSQL v1.1.0 with postgreSQL 9.6.0.

Is it possible at all?

best regards Sergey

[roji]

You'll have to provide more info on what you want to do, what do you mean by "comments on columns"? Can you provide an example?

[smigalni]

I am trying to do something like this:
COMMENT ON COLUMN my_table.my_column IS 'Employee ID number';

I would like to provide some comments for meg columns in the database when I do Code First approach.

[roji]

This is currently not supported in the EF Core provider, but it's a pretty good suggestion! I'll try to do it for 1.2.

[roji]

BTW, as a workaround, you can always use raw SQL in migrations to add comments to your tables, columns or anything else.

[smigalni]

Thanks. Completly forgot about raw SQL.

[roji]

Have completed support for this, will be released in 1.2.

[tetri]

Thanks. Completly forgot about raw SQL.

same here

shame on me lol