Postgres Pro
Downloads
Home   >   mailing lists

NOVALIDATE in postgresql? - Mailing list pgsql-general

From SHARMILA JOTHIRAJAH
Subject NOVALIDATE in postgresql?
Date
Msg-id 3929.4338.qm@web110709.mail.gq1.yahoo.com
Whole thread Raw
Responses Re: NOVALIDATE in postgresql?  (Osvaldo Kussama <osvaldo.kussama@gmail.com>)
Re: NOVALIDATE in postgresql?  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
Tree view 
Hi
In Oracle I can use the NOVALIDATE for constraints... like this
ALTER TABLE employee ADD
CONSTRAINT emp_ck
 CHECK (married IN ('Y','N')) NO VALIDATE;

When the table is already populated this will be faster. Can you do the same in Postgresql?
Thanks
Sharmila

pgsql-general by date:

Previous
From: SHARMILA JOTHIRAJAH
Date:
Subject: Re: How to pipe the psql copy command to Unix 'Date' command
Next
From: Osvaldo Kussama
Date:
Subject: Re: NOVALIDATE in postgresql?