Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id UAA27746 for postgres-dist; Sat, 15 Jan 1994 20:56:27 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199401160456.UAA27746@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id UAA27737 for ; Sat, 15 Jan 1994 20:56:26 -0800 Received: from localhost (aoki@localhost) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) id UAA01677; Sat, 15 Jan 1994 20:55:02 -0800 Message-Id: <199401160455.UAA01677@faerie.CS.Berkeley.EDU> From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: G.SCHNIEDER@BIONIC.zer.de Cc: postgres@postgres.Berkeley.EDU Subject: Re: attribute names of a class In-reply-to: Your message of Sat, 15 Jan 1994 18:53:53 +0100 <39.42240@bionic.zer.de> Date: Sat, 15 Jan 1994 20:55:01 -0800 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Sat, 15 Jan 94 20:56:27 -0800 Resent-XMts: smtp G.SCHNIEDER@BIONIC.zer.de (Gregor Schnieder) writes: > retrieve (c.relname, c.relnatts, c.reltuples, a.attname) > from c in pg_class, a in pg_attribute > where c.relname = "adress" and a.attnum > 0 -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki