Adding comment to column when I create table in PostgreSQL?
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