On Sun, 22 Aug 2010 10:27:52 -0700, c k <shreeseva.learning@xxxxxxxxx>
wrote:
Hi all,
As I am using MS Access for a long time, many tools like ms access
provides
a way to get the list of columns from a query. (using filed list in combo
boxes in ms access). But is it possible to get such list of columns from
a
query where it is not known to the user, that which columns are defined
in
the base 'SELECT' statement? How? I dynamically created SQL statements
many
times this situation occurs where the columns are not fixed and we have
to
get the list of columns from such a query.
Thanks in advance.
I am removing psql-admin from the Cc to avoid crossposting. Besides, I
am not sure if it is on-topic there or not.
Which version of PostgreSQL? Anyway, if you create the SELECT statement
dynamically you could know a priori what columns would result, AFAIU.
--
Octavio.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
