postgresql建表带注释,在PostgreSQL中创建表时在列中添加注释？

How can I add comment to column in PostgreSQL?

create table session_log (

UserId int index not null,

PhoneNumber int index);

解决方案

Comments are attached to a column using the comment statement:

create table session_log

(

userid int not null,

phonenumber int

);

comment on column session_log.userid is 'The user ID';

comment on column session_log.phonenumber is 'The phone number including the area code';

You can also add a comment to the table:

comment on table session_log is 'Our session logs';

Additionally: int index is invalid.

If you want to create an index on a column, you do that using the create index statement:

create index on session_log(phonenumber);

If you want an index over both columns use:

create index on session_log(userid, phonenumber);

You probably want to define the userid as the primary key. This is done using the following syntax (and not using int index):

create table session_log

(

UserId int primary key,

PhoneNumber int

);

Defining a column as the primary key implicitly makes it not null