From spam@freeuk.com Mon Aug 20 14:19:47 2001 Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7KEJlP33366 for ; Mon, 20 Aug 2001 10:19:47 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7HIX1P00438 for ; Fri, 17 Aug 2001 14:33:01 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f7HINJo86866 for pgsql-sql@postgresql.org; Fri, 17 Aug 2001 14:23:19 -0400 (EDT) (envelope-from news) X-Newsgroups: comp.databases.postgresql.sql From: spam@freeuk.com (Stephen Patterson) Subject: Finding table constraints Reply-To: see.the.sig@news.tht.net Message-ID: User-Agent: slrn/0.9.7.1 (Linux) Lines: 7 Date: Fri, 17 Aug 2001 18:23:17 GMT X-Complaints-To: abuse@freeuk.net To: pgsql-sql@postgresql.org X-Archive-Number: 200108/243 X-Sequence-Number: 4484 Is there any way to find out what constraints have been set on a table or on columns in a table? -- Stephen Patterson http://home.freeuk.net/s.patterson/ s.patterson@SPAM.freeuk.com (remove spam to reply) ICBM address 54-22-0N 0-28-0W From johs@copyleft.no Mon Aug 20 19:25:45 2001 Received: from unity.copyleft.no (unity.copyleft.no [212.71.72.23]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7KJPjP60292 for ; Mon, 20 Aug 2001 15:25:45 -0400 (EDT) (envelope-from johs@unity.copyleft.no) Received: from johs by unity.copyleft.no with local (Exim 3.12 #1) id 15YugA-0005tM-00; Mon, 20 Aug 2001 21:25:42 +0200 Date: Mon, 20 Aug 2001 21:25:42 +0200 From: =?iso-8859-1?Q?Johannes_Gr=F8dem?= To: Stephen Patterson Cc: pgsql-sql@postgresql.org Subject: Re: Finding table constraints Message-ID: <20010820212542.A19747@unity.copyleft.no> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from spam@freeuk.com on Fri, Aug 17, 2001 at 06:23:17PM +0000 Organization: Copyleft Software AS X-Archive-Number: 200108/252 X-Sequence-Number: 4490 > Is there any way to find out what constraints have been set on a table > or on columns in a table? Take a look at the source for psql. -- johs From jd_j2ee@yahoo.com Mon Oct 21 13:46:33 2002 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C922A477308 for ; Mon, 21 Oct 2002 09:46:33 -0400 (EDT) Received: from web21110.mail.yahoo.com (web21110.mail.yahoo.com [216.136.227.112]) by postgresql.org (Postfix) with SMTP id AE9B3476DED for ; Mon, 21 Oct 2002 09:41:40 -0400 (EDT) Message-ID: <20021021134144.22877.qmail@web21110.mail.yahoo.com> Received: from [128.214.205.25] by web21110.mail.yahoo.com via HTTP; Mon, 21 Oct 2002 06:41:44 PDT Date: Mon, 21 Oct 2002 06:41:44 -0700 (PDT) From: Jadcharla Srinivas Subject: Finding table constraints To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-404327723-1035207704=:22861" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/288 X-Sequence-Number: 10005 --0-404327723-1035207704=:22861 Content-Type: text/plain; charset=us-ascii function SetDomain(d) { document.domain = d; } Hi , I have a small doubt , if any one knows how to know Constraints of a table in Oracle9i , won't you please tell me Warm Regards Jadcharla Srinivas Viipurinkatu 1C 86,00510 HELSINKI,FINLAND. Phone:358408208487(Moblie) --------------------------------- Do you Yahoo!? Y! Web Hosting - Let the expert host your web site --0-404327723-1035207704=:22861 Content-Type: text/html; charset=us-ascii

Hi  ,

I have a small doubt , if any one knows how to know Constraints of a table in Oracle9i , won't you please tell me



 Warm Regards

Jadcharla Srinivas
Viipurinkatu 1C 86,00510 HELSINKI,FINLAND.
Phone:358408208487(Moblie)


Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site --0-404327723-1035207704=:22861--