Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id CAA28070 for postgres-redist; Tue, 25 Apr 1995 02:40:39 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199504250940.CAA28070@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from sunic.sunet.se (sunic.sunet.se [192.36.125.2]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id CAA28060 for ; Tue, 25 Apr 1995 02:40:24 -0700 Received: from cocos.fuw.edu.pl by sunic.sunet.se (8.6.8/2.03) id LAA20067; Tue, 25 Apr 1995 11:40:06 +0200 Received: from ccfs1.fuw.edu.pl by cocos.fuw.edu.pl (4.1/SMI-4.1) id AA11135; Tue, 25 Apr 95 11:39:58 +0200 Received: by ccfs1.fuw.edu.pl (4.1/SMI-4.1) id AA09425; Tue, 25 Apr 95 11:39:54 +0200 Date: Tue, 25 Apr 1995 11:39:54 +0200 (MET DST) From: Kacper Nowicki X-Sender: kacper@ccfs1 To: Postgres Mailing List Subject: How to get list of classes without indexes Message-Id: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Tue, 25 Apr 95 02:40:38 -0700 Resent-XMts: smtp Hi, I use following query to get list of classes in database. Unfortunatelly I get also indexes created for those classes. How could I exclude indexes from this list ? retrieve (pg_class.relname) I select user classes removing everything beginning with 'pg_'. Is there a better way to get rid of POSTGRES internal classes ? Thanks in advance, Kacper ------------------------------------------------------------------------ Kacper Nowicki e-mail: Kacper.Nowicki@fuw.edu.pl Warsaw University ================================= Physics Department Computer Center Hoza 69, 00-681 Warszawa, Poland fax:(48)(22)294309,(48)(2)6226154 ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU". If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ============================================================================== URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/