DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=YTRVyl0nhpVJfIbE2mVwYnwKpq+chHiZwuJm6HfY/J/WMZsS36/l0TxUYvhlgvOXqM
	WtwXslYlEZVtWnQHqkZUZl3Mjk85ze9KgOOTVzrk9KS1P4ODtvdzLDigFLVBdn0rT2ri
	z2I57gl1XgAJzeMs7JFs/70zTJlKmS4xYSkL8=
MIME-Version: 1.0
In-Reply-To: <1296679230744-3368417.post@n5.nabble.com>
References: <1296679230744-3368417.post@n5.nabble.com>
Date: Fri, 4 Feb 2011 08:38:40 -0800
Message-ID: <AANLkTimh55F3Pin7Uogoijad3cX4=-tR8EX+RE6VQ3+f@mail.gmail.com>
Subject: Re: How to checking the existance of constraints for a table?
From: bricklen <bricklen@gmail.com>
To: creationw <mr.creation.register@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On Wed, Feb 2, 2011 at 12:40 PM, creationw
<mr.creation.register@gmail.com> wrote:
>
> Hello,
>
> I have a sample table describe as follows, anyone knows how to checking t=
he
> existence of a constraint?
>
> oviddb=3D# \d myTable
>
> =C2=A0Column =C2=A0| =C2=A0 Type =C2=A0 | Modifiers
> ---------+----------+-----------
> =C2=A0orderid | smallint | not null
> =C2=A0modelid | smallint | not null
>
> Indexes:
> =C2=A0 =C2=A0"mytable_orderid_key" UNIQUE, btree (orderid)
>
> For example, how to know that myTable has a constraint with name
> "mytable_orderid_key"?

You could try checking the information_schema.table_constraints view.
Eg. select * from information_schema.table_constraints where
table_name=3D'myTable'