[ADMIN] ALTER TABLE - UNIQUE constraint

[sreedhar]

Hi all,

I am new to PostgreSQL

how can i give the following satement in PostgreSQL

ALTER TABLE tblDayTransaction WITH NOCHECK ADD 
  UNIQUE  NON
 (
  empid,
  ppid,
  transdate
 ) 

regards,
sreedhar


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]