Received: from bom3.vsnl.net.in (bom3.vsnl.net.in [202.54.4.24]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA89054 for ; Tue, 21 Sep 1999 08:15:51 -0400 (EDT) (envelope-from ugtech@bom3.vsnl.net.in) Received: from Cosmos (PPP46-30.lvsb.vsnl.net.in [202.54.46.30]) by bom3.vsnl.net.in (8.9.0/8.9.0) with SMTP id RAA25200 for ; Tue, 21 Sep 1999 17:45:23 +0530 (IST) Message-ID: <000801bf042c$3f971000$030136ca@ugtech.com> From: "Geeta Mahesh" To: Subject: Table name of a select query. Date: Tue, 21 Sep 1999 17:54:26 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01BF045A.582B8C80" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01BF045A.582B8C80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,=20 I am currently implementing an application using the libpq interface of = pgsql.=20 I have the foll. questions. Please help.=20 1. Is there any way by which I can retreive the table name from my = select query.=20 2. Is there any way by which I can query the database schema to get the = column names from the table without performing a=20 select/fetch. What is the most efficient method to get the column = info. =20 Please let me know.=20 Thanks Geeta. ------=_NextPart_000_0005_01BF045A.582B8C80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I am currently implementing an application using the = libpq=20 interface of pgsql.

I have the foll. questions. Please help. =

1. Is there any way by which I can retreive the = table=20 name from my select query.

2. Is there any way by which I can query the = database schema=20 to get the column names from the table without performing a =

select/fetch. What is the most = efficient=20 method to get the column info.

Please let me know.

Thanks

Geeta.

------=_NextPart_000_0005_01BF045A.582B8C80--