"Bantamess" <bantamess@yahoo.co.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