Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 3E765475995 for ; Fri, 3 May 2002 20:33:39 -0400 (EDT) Received: from ux7.cso.uiuc.edu (ux7.cso.uiuc.edu [128.174.5.35]) by postgresql.org (Postfix) with ESMTP id 528194758F5 for ; Fri, 3 May 2002 20:33:24 -0400 (EDT) Received: from puckster (isr6207.urh.uiuc.edu [130.126.212.185]) by ux7.cso.uiuc.edu (8.11.0/8.11.0) with SMTP id g440XR502120 for ; Fri, 3 May 2002 19:33:27 -0500 (CDT) Message-ID: <006801c1f303$098c36c0$b9d47e82@puckster> From: "matt" To: References: <008c01c1e73b$b98cbe60$b9d47e82@puckster> Subject: Re: Internal Query Date: Fri, 3 May 2002 19:31:30 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200205/4 X-Sequence-Number: 1362 So, to do an internal query, I can just do: char * query = "SELECT column from pg_attributes WHERE pg_attributes.table = table_name"; PGresult *result; <--where is PGresult stored?? what do i need to include to get this struct? result = PSQLexec(query); What's the difference between PSQLexec and pg_exec? And then, how do i access the information? I see commands like pg_result in src/interfaces/libpgtcl/pgtclCmds.c but are these backend commands that I do run inside a given function? the pg_stuff looks almost like front end stuff... sincerly, matt