Adding comment to column when I create table in PostgreSQL?

Question

How can I add comment to column in PostgreSQL?

create table session_log (                 UserId int index not null,                 PhoneNumber int index);  

Answer 1

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