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 UAA27687 for postgres-dist; Sat, 15 Jan 1994 20:42:17 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199401160442.UAA27687@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 mail.Germany.EU.net (mail.Germany.EU.net [192.76.144.65]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id UAA27678 for ; Sat, 15 Jan 1994 20:42:15 -0800 Received: by mail.Germany.EU.net(EUnetD-2.3.1.c) via EUnet id YZ20950; Sun, 16 Jan 1994 05:42:37 +0100 Received: from uzercp.zer.sub.org by subnet.sub.net with bsmtp id <15984>; Sun, 16 Jan 1994 05:40:53 +0100 Received: by uzercp.zer.sub.org (uzcopy); Sat, 15 Jan 1994 23:18:29 CET Date: Sat, 15 Jan 1994 18:53:53 +0100 From: G.SCHNIEDER@BIONIC.zer.de (Gregor Schnieder) Reply-To: G.SCHNIEDER@BIONIC.zer.de X-Mailer: ZERBERUS V5.2 Rel2.2 Message-Id: <39.42240@bionic.zer.de> To: postgres@postgres.Berkeley.EDU Subject: attribute names of a class Organization: "Bielefelder MailBox AG" im FoeBuD e.V. X-Gateway: NETCALL3.8 UU uzercp.zer.sub.org [UZERCP V4.46], ZCONNECT UU uzercp.zer.sub.org [CONNECT*UZERCP V0.78] Content-Length: 839 Lines: 30 Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Sat, 15 Jan 94 20:42:17 -0800 Resent-XMts: smtp Hallo everyboddy, I'am new in postgress. Who can help me? I try to get the attribute names in a class, e.g. my own class adress. There are attributes like post_name, pre_name, zip_code, town, street, etc. ... I do the retrieve command in the followeing way. retrieve (c.relname, c.relnatts, c.reltuples, a.attname) from c in pg_class, a in pg_attribute where c.relname = "adress" The list I get back is very long, because there are many attributes like tmin, tmax, vtype, etc. in it. Also the attribute names of the class I created, are included. But how can I get back a short list? (post_name, pre_name, ... ) cu Gregor #include never touch a running program! # e-mail: g.schnieder@bionic.zer.de # voice : +49 521 883599 # # adress: Gregor Schnieder # Im Bergsiek 29 # D-33739 Bielefeld