Return-Path: postman 
Delivery-Date: Wed, 25 Aug 93 10:13:21 PDT
Return-Path: postman
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA17493; Wed, 25 Aug 93 10:07:35 -0700
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9308251707.AA17493@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: aoki@postgres.Berkeley.EDU
Received: from faerie.CS.Berkeley.EDU by postgres.Berkeley.EDU (5.61/1.29)
	id AA17485; Wed, 25 Aug 93 10:07:29 -0700
Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.1C/8.1B) with SMTP id KAA03368; Wed, 25 Aug 1993 10:17:04 -0700
Message-Id: <199308251717.KAA03368@faerie.CS.Berkeley.EDU>
From: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
To: dfleenor@nettech.com (super dave?)
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: script 
In-Reply-To: Your message of Wed, 25 Aug 1993 09:43:48 -0500 (EDT) 
	     <9308251343.AA35046@nettech1.nettech.com> 
Date: Wed, 25 Aug 93 10:17:03 -0700
X-Sender: aoki@postgres.Berkeley.EDU
X-Mts: smtp
Resent-To: postgres-dist
Resent-Date: Wed, 25 Aug 93 10:07:33 PDT

dfleenor@nettech.com (super dave?) writes:
> I need to create a class with a rather large number of attributes, and would
> like a script to do this for me, because the class will probably change. How
> do I go about doing this (an example would be nice).

look in the manual under "create" and "addattr" as well as under 
"PQexec" (under "libpq").

note that there is no way to remove attributes (safely) without 
(essentially) doing a reload of the data, though you can rename
attributes using "rename".
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki