X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EBEDB475A45 for ; Tue, 25 Feb 2003 10:34:27 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 43386-02 for ; Tue, 25 Feb 2003 10:34:17 -0500 (EST) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by postgresql.org (Postfix) with SMTP id 634974758F1 for ; Tue, 25 Feb 2003 10:23:15 -0500 (EST) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Tue Feb 25 16:23:19 2003 +0100 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id QAA08987; Tue, 25 Feb 2003 16:23:18 +0100 (MET) Message-ID: <3E5B8A65.15F2E0A2@rodos.fzk.de> Date: Tue, 25 Feb 2003 16:23:18 +0100 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Cc: rutes@eselx.ipl.pt Subject: Re: how can i drop a constraint Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/550 X-Sequence-Number: 11948 > > > > > i've got some tables where constraints don't have an explicit name, > how can > > i drop them. > > > > Refer to the system catalogs section within the documentation. > pg_relcheck keeps track of constraints. > > More precisely select relname , rcname from pg_class join pg_relcheck on ( pg_relcheck.rcrelid = pg_class.oid ) ; Regards, Christoph