> Where do you need this information?
I'm writing some code that takes a given query, and generates type-safe
bindings for it, so people can write SQL queries and get structs (or vectors of
structs) out the other end. So I'm pretty flexible about where I get it, given
that it'll be part of my
"Wesley Aptekar-Cassels" writes:
> I am interested in figuring out how to get the names and types of the
> columns from an arbitrary query.
Where do you need this information? Usually the easiest way is to
prepare (plan) the query and then extract metadata, for instance
PQprepare and
Hi all,
I am interested in figuring out how to get the names and types of the columns
from an arbitrary query. Essentially, I want to be able to take a query like:
CREATE TABLE foo(
bar bigserial,
baz varchar(256)
);
SELECT * FROM foo WHERE bar = 42;
and figure out programmatically
