From: matt <vagnoni@uiuc.edu>
To: pgsql-docs@postgresql.org
Subject: Re: Internal Query
Date: Fri, 3 May 2002 19:31:30 -0500
Message-ID: <006801c1f303$098c36c0$b9d47e82@puckster> (raw)
References: <008c01c1e73b$b98cbe60$b9d47e82@puckster>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: vagnoni@uiuc.edu
Subject: Re: Internal Query
In-Reply-To: <006801c1f303$098c36c0$b9d47e82@puckster>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox