From 7b08f1155e1cb8bf263c3570eeb119970407a037 Mon Sep 17 00:00:00 2001
From: Kamal Wickramanayake <kamal@inbox.lk>
Date: Sun, 19 Apr 2026 16:29:36 +0530
Subject: Added pgsql basic sql

---
 postgresql/01-basics/basic.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 postgresql/01-basics/basic.sql

(limited to 'postgresql/01-basics/basic.sql')

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;
-- 
cgit v1.2.3

