ALTER TABLE - UNIQUE constraint

From: "sreedhar" <sreedhar(at)lucidindia(dot)net>
To: "PostgreSQL" <pgsql-admin(at)postgresql(dot)org>
Subject: ALTER TABLE - UNIQUE constraint
Date: 2002-02-18 08:56:55
Message-ID: 00f001c1b85a$39001a40$1201a8c0@lucidindia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Karel Zak 2002-02-18 09:21:21 Re: CREATE TABLE privilege - will it be implemented?
Previous Message Bruce Momjian 2002-02-18 06:46:08 Re: CREATE TABLE privilege - will it be implemented?