database/postgresql/01-basics/basic.sql


1
2
3
4
5
6
7
8
9
10
11
12

create table user_account (
  uid serial primary key,
  username text unique not null,
  name text,
  password text
);

insert into user_account (username, name, password) values ('kamal', 'Kamal Wickramanayake', 'e99a18c428cb38d5f260853678922e03');

insert into user_account (username, name, password) values ('kamal2', 'Kamal Wickramanayake', 'e99a18c428cb38d5f260853678922e03');

select * from user_account;