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