Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA11205; Mon, 26 Jul 93 14:31:17 -0700
Date: Mon, 26 Jul 93 14:31:17 -0700
Message-Id: <9307262131.AA11205@postgres.Berkeley.EDU>
From: Patchaya Pitakpaivan <pp@cacs.usl.edu>
Subject: Remove attribute?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

Hi,

I am writing a C program that interfaces with POSTGRES backend, using LIBPQ.
POSTGRES that we have here is Version 4.0. I have some questions :

1. From the reference manual we can add attribute to a class using ADDATTR.
Is it possible to remove attributes from a class? If it is, what is the command
to be used?

2. When using monitor to retrieve instances of the class, the result that 
POSTGRES displays is in the table form, like :


Query sent to backend is "retrieve (emp.all)"
-----------------------------
| name        | address     |
-----------------------------
| Michael Smith| 2308 Right Street|
-----------------------------
| John Luke Picard| Enterprise 101|
-----------------------------

Can we adjust the format of the table so that the columns width is wider and 
the table is in more "good looking" form?

3. In my program, I try to display the instances of the class in X window. Are
there any commands that I can retrieve all instances of the class with its 
attribute names (as heading) without having to pass all instances through portal.
I try to use copy command and then use PQgetline. But the result is not in good 
format and there is no heading for those instances.

4. Last question. I want to implement the extended relational operators in 
POSTGRES. Is FASTPATH the only way to do this? How can I get more information
about FASTPATH?

Any suggestions would be very appreciated.

Thank you.




Patchaya Pitakpaivan.
Graduate student.
University of Southwestern Louisiana.
Lafayette. Louisiana.

email : pp@swamp.cacs.usl.edu