By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE example (
a integer,
b integer,
c integer,
PRIMARY KEY (a, c)
);
INSERT INTO example
VALUES (1,2,3),(2,2,3),(2,3,1)
SELECT *
FROM example
| a | b | c |
|---|---|---|
| 1 | 2 | 3 |
| 2 | 3 | 1 |
| 2 | 2 | 3 |