| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | c k <shreeseva(dot)learning(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] getting list of columns from a query |
| Date: | 2010-08-22 23:26:32 |
| Message-ID: | AANLkTi=FU+=humCnqD-t58rwQag4j5HowD=sZgHWYnih@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Hello
2010/8/22 c k <shreeseva(dot)learning(at)gmail(dot)com>:
> 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.
>
Yes, it is possible, you can get a description of prepared statement's
result. See: PQprepare, PQdescribePrepared, PQdescribePortal. These
functions are in client postgresql library -
http://www.postgresql.org/docs/8.4/interactive/libpq-exec.html#LIBPQ-EXEC-MAIN
Regards
Pavel Stehule
> CPK
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenichiro Tanaka | 2010-08-23 02:02:03 | Re: installing Postgres 8.3 msi getting `Error` = 2888 |
| Previous Message | Daniel J. Summers | 2010-08-22 21:18:47 | Re: getting list of columns from a query |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yaroslav Tykhiy | 2010-08-23 01:56:25 | Re: Warm Standby and resetting the primary as a standby |
| Previous Message | Daniel J. Summers | 2010-08-22 21:18:47 | Re: getting list of columns from a query |