Received: from orion3.ori-ind.com (IDENT:root@[206.81.197.190]) by hub.org (8.9.1/8.9.1) with ESMTP id TAA27360 for ; Tue, 10 Nov 1998 19:35:14 -0500 (EST) (envelope-from ken@ori-ind.com) Received: from Ken.ori-ind.com (avanti.ori-ind.com [192.168.61.99]) by orion3.ori-ind.com (8.8.7/8.8.4) with SMTP id QAA27954 for ; Tue, 10 Nov 1998 16:41:47 GMT Message-Id: <3.0.1.32.19981110163802.007b72f0@ori-ind.com> X-Sender: ken@ori-ind.com X-Mailer: Windows Eudora Pro Version 3.0.1 (32) Date: Tue, 10 Nov 1998 16:38:02 -0800 To: pgsql-interfaces@postgreSQL.org From: "Ken J. Wright" Subject: how to obtain column info Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" With libpq, how do you obtain column info (like type) for a table *before* returning a result set? For instance, knowing the column type before constructing an insert statement. A date will need quotes, a number won't, a string will, etc. Thanks, Ken