Added pgsql basic sql

1 files changed, 12 insertions, 0 deletions

diff --git a/postgresql/01-basics/basic.sql b/postgresql/01-basics/basic.sql
new file mode 100644
index 0000000..bbe2bef
--- /dev/null
+++ b/postgresql/01-basics/basic.sql
@@ -0,0 +1,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;