CREATE TABLE USERS_PART (
   user_id serial,
   username VARCHAR(50),
   user_role VARCHAR(1),
   created_date DATE DEFAULT CURRENT_DATE,
   last_updated_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) PARTITION BY LIST(user_role);
 
-- Inserts would currently fail as we haven't defined any partitions for this table
 
CREATE TABLE USERS_PART_A
PARTITION OF USERS_PART 
FOR VALUES IN ('A');
 
-- Inserts will now only work with a user_role of A