X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B1AB99FA5DD for ; Tue, 4 Jul 2006 13:59:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 64997-08 for ; Tue, 4 Jul 2006 13:59:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.zanthus.com.br (mail.zanthus.com.br [200.212.65.85]) by postgresql.org (Postfix) with ESMTP id 8D3EE9FA4A5 for ; Tue, 4 Jul 2006 13:59:28 -0300 (ADT) Received: from cprsakai ([192.168.0.71]) by mail.zanthus.com.br (8.13.4/8.13.4/Debian-3) with ESMTP id k64H3Jna018334 for ; Tue, 4 Jul 2006 14:03:19 -0300 Reply-To: From: "Rodrigo Sakai" To: Subject: Null attributes Date: Tue, 4 Jul 2006 13:59:56 -0300 Message-ID: <001201c69f8b$46df07d0$4700a8c0@TREEZANTHUS> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0013_01C69F72.219419C0" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 Thread-Index: Acafi0aBj9NxhplHTZmjo7GD7ZnJrw== X-Zanthus-MailScanner: Found to be clean X-Zanthus-MailScanner-From: rodrigo.sakai@zanthus.com.br X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/41 X-Sequence-Number: 25615 This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C69F72.219419C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit How can I get all attributes that is not null + don't have defaults + is not PKs??? I know I have to use system catalog, but I have some Pks that is multicolumn! Any help?? Rodrigo Sakai Administrador de Banco de Dados *(11) 3750-7075 * rodrigo.sakai@zanthus.com.br ------=_NextPart_000_0013_01C69F72.219419C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

How can I get all attributes that is = not null + don’t have defaults + is not PKs??? I know I have to use system catalog, but I have some Pks that is = multicolumn!

Any help??

Rodrigo = Sakai

Administrador de Banco de = Dados

É(11) = 3750-7075

* rodrigo.sakai@zanthus.com.br=

------=_NextPart_000_0013_01C69F72.219419C0--