Re: getting list of columns from a query
От | Octavio Alvarez |
---|---|
Тема | Re: getting list of columns from a query |
Дата | |
Msg-id | op.vhuvz6hd4oyyg1@localhost.localdomain обсуждение исходный текст |
Ответ на | getting list of columns from a query (c k <shreeseva.learning@gmail.com>) |
Список | pgsql-general |
On Sun, 22 Aug 2010 10:27:52 -0700, c k <shreeseva.learning@gmail.com> 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.
В списке pgsql-general по дате отправления: