w == wmoran@xxxxxxxxxxxxxxxxx writes: ... w> Your primary key can span multiple columns, i.e. w> PRIMARY KEY(jobclock_id, employee_id, machine_id) w> Could be more columns. w> Keep in mind that this ensures that the combination of all those w> columns is unique, which may or may not be what you want. Sure. I realize that a primary key can be made up of multiple columns, but a unique constraint across the columns I need as suggested by Matthew is what I was looking for. Thanks. -- Brandon -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
