"Bantamess" <bantamess(at)yahoo(dot)co(dot)uk> writes:
> Hello can any body tell me how to code a table with dual primary keys?
Do you mean a two-column composite primary key? Two independent primary
keys is nonsensical --- you should pick just one of them to be
considered the "primary" key.
If you want a composite primary key, the syntax is
primary key (f1, f2)
regards, tom lane