title: PostgreSQL composite primary key
body: <p>In MySQL, when I create a composite primary key, say with columns <code>X, Y, Z</code>, then all three columns become indexes automatically. Does the same happen for Postgres?</p>