Re: Internal Query - Mailing list pgsql-docs

From matt
Subject Re: Internal Query
Date
Msg-id 006801c1f303$098c36c0$b9d47e82@puckster
Whole thread Raw
In response to Re: Getting Metadata  ("matt" <vagnoni@uiuc.edu>)
List pgsql-docs
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




pgsql-docs by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: timestamp() functions still documented
Next
From: Jean-Paul ARGUDO
Date:
Subject: Re: Migrating Oracle to PostgreSQL