#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Cape Town, South Africa
    Posts
    13
    Rep Power
    0

    How to create concatenated primary key in postgresql?


    Just want to know how to create a concatenated primary key in postgresql - cant seem to find any related help using google.
    Thanks
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Cape Town, South Africa
    Posts
    13
    Rep Power
    0

    This could be a correct example


    ALTER TABLE "billing" ADD PRIMARY KEY ("bill_id","bill_agentid")

IMN logo majestic logo threadwatch logo seochat tools logo