- Home
- PostgreSQL
- Introduction to Creating Tables in PostgreSQL
Introduction to Creating Tables in PostgreSQL
By
CREATE TABLE IF NOT EXISTS "Users" (
"id" text primary key,
"fname" text,
"lname" text,
"email" text default '',
"phone" text default '',
"client" text,
"passwordHash" text,
"passwordSalt" text,
"status" int,
"type" int default 0,
"active" boolean default true,
"_lm" timestamp without time zone not null,
"_lmBy" text,
"_cBy" text,
"_cOn" timestamp without time zone not null,
"removed" boolean default false,
UNIQUE ("d)
);