Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group