Return-Path: pg_adm@postgres.berkeley.edu Received: by postgres.Berkeley.EDU (5.61/1.29) id AA10064; Thu, 19 Aug 93 12:01:11 -0700 Message-Id: <9308191901.AA10064@postgres.Berkeley.EDU> From: turk@andrews.edu (Daniel Turk) Subject: Re: data types To: postgres@postgres.berkeley.edu Sender: pg_adm@postgres.berkeley.edu To: wolska@maccs.dcss.mcmaster.ca (Ewa Lata-Wolska) Date: Thu, 19 Aug 1993 15:09:19 -0400 (EDT) Cc: postgres@postgres.berkeley.edu In-Reply-To: from "Ewa Lata-Wolska" at Aug 19, 93 02:45:00 pm X-Mailer: ELM [version 2.4 PL21] Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Length: 1019 > Hi! I am not sure if it works but try the function from LIBPQ PQftype > which returns the type of the field. By the way do you have any precompiler > when writing C program and use POSTGRES or you just use LIBPQ. > Ewa Lata-Wolska Computer Science McMaster University > Hamilton,Ont wolska@maccs.mcmaster.ca Yes, this returns an "internal type number". I'd like to get something that will allow me to printout a user-interpretable name of the data types..... If there is a way (within C/Postgres/LibPQ) to convert the type number to know what type it stands for then I can do what I want. I'd just think that Postgres would have all this internally to itself and that I should be able to get access to it. -------------------------------------------------------------------------- Dan Turk Computer Science & Information Systems Andrews University Berrien Springs, MI turk@andrews.edu (616) 471-3426 ==========================================================================