PostgreSQL Sharding with Declarative Partition Example

database.sql

CREATE TYPE jeniskelamin AS ENUM('l', 'p');

CREATE TABLE users (
  username VARCHAR(255) NOT NULL,
  password VARCHAR(255) NOT NULL,
  jk jeniskelamin NOT NULL
) PARTITION BY LIST(jk);

CREATE TABLE users_l PARTITION OF users FOR VALUES IN('l');
CREATE TABLE users_p PARTITION OF users FOR VALUES IN('p');

INSERT INTO users VALUES ('hadihammurabi', '123123aaa', 'l');

SELECT * FROM users;
SELECT * FROM users_l;
SELECT * FROM users_p;