Contoh table Users
Create User :
CREATE TABLE "public"."users" (
"id" int4 DEFAULT NOT NULL,
"username" varchar(100) NOT NULL,
"password" varchar(80) NOT NULL,
"email" varchar(100) NOT NULL,
"first_name" varchar(50),
"last_name" varchar(50),
"company" varchar(100),
"phone" varchar(20),
"tenant_id" int4 DEFAULT 0 NOT NULL,
"user_level" int2 DEFAULT 2 NOT NULL
)
WITH (OIDS=FALSE)
Menambahkan Sequence pada table Users
create sequence users_id_seq;
ALTER TABLE public.users
ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
Cara melihat class postgreeSql
SELECT c.* FROM pg_class c WHERE c.relkind = 'S';
