Return-Path: owner-postman Delivery-Date: Mon, 25 Apr 94 18:48:49 -0700 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 PAA08707 for postgres-redist; Mon, 25 Apr 1994 15:55:23 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199404252255.PAA08707@nobozo.CS.Berkeley.EDU> 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 PAA08698 for ; Mon, 25 Apr 1994 15:55:23 -0700 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id PAA08592; Mon, 25 Apr 1994 15:54:53 -0700 Message-Id: <199404252254.PAA08592@faerie.CS.Berkeley.EDU> X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: perera@pollux.cs.uga.edu Cc: postgres@postgres.Berkeley.EDU Subject: Re: "define view" question Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki) In-reply-to: Your message of Mon, 25 Apr 94 17:44:16 EDT <9404252144.AA03385@pollux.cs.uga.edu> Date: Mon, 25 Apr 94 15:54:52 -0700 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-redist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Mon, 25 Apr 94 15:55:23 -0700 Resent-XMts: smtp perera@pollux.cs.uga.edu writes: > If I define a view like this > define view demo ( s.sname ) \g > How do I do away with demo after I am done ? oops -- "remove view" *does* exist but there's no man page for it.. the syntax is just remove view demo there are some examples of this in the regression tests. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki