getting list of columns from a query

getting list of columns from a query

am 22.08.2010 19:27:52 von C K

--00c09f971fac11dd24048e6cdaf3
Content-Type: text/plain; charset=ISO-8859-1

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.

CPK

--00c09f971fac11dd24048e6cdaf3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all,
As I am using MS Access for a long time, many tools like ms acce=
ss provides a way to get the list of columns from a query. (using filed lis=
t in combo boxes in ms access). But is it possible to get such list of colu=
mns 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 f=
ixed and we have to get the list of columns from such a query.

Thanks in advance.

CPK


--00c09f971fac11dd24048e6cdaf3--

Re: getting list of columns from a query

am 22.08.2010 23:18:47 von daniel.lists

On 08/22/2010 05:27 PM, c k wrote:
> 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.

What language are you using, and what technique in that language are you
using? (ex. Java and JDBC, C# and ADO.NET, PHP and PDO, or PHP and
PostgreSQL native) Most of these provide a way to get to the column
names, but they're language- and technique-dependent.


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: [GENERAL] getting list of columns from a query

am 23.08.2010 01:26:32 von Pavel Stehule

Hello

2010/8/22 c k :
> 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.ht ml#LIBPQ-EXEC-MAIN

Regards

Pavel Stehule

> CPK
>

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: [GENERAL] getting list of columns from a query

am 23.08.2010 10:02:00 von C K

--0015175cb71c355a17048e791041
Content-Type: text/plain; charset=ISO-8859-1

I am using PostgreSQL 8.4 on Fedora Linux 13 and using MS Access as the
front end for our application. It is not the problem associated with MS
Access. I got the some entries while searching for the said topic that
Oracle provides such facility.
DESCRIBE SELECT LIST which gives the details about the column names and data
types. I need such thing in postgresql, because users of my application can
execute custom query and then select the aggregate function to be applied to
the selected columns. This can be done using Pivot Table/Chart in MS Access,
but it is not sufficient, rather it will be better if postgres has support
for this.

Thanks and regards to all,

CPK

On Mon, Aug 23, 2010 at 4:56 AM, Pavel Stehule wrote:

> Hello
>
> 2010/8/22 c k :
> > 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.ht ml#LIBPQ-EXEC-MAIN
>
> Regards
>
> Pavel Stehule
>
> > CPK
> >
>

--0015175cb71c355a17048e791041
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I am using PostgreSQL 8.4 on Fedora Linux 13 and using MS Access as the fro=
nt end for our application. It is not the problem associated with MS Access=
.. I got the some entries while searching for the said topic that Oracle pro=
vides such facility.

DESCRIBE SELECT LIST which gives the details about the column names and dat=
a types. I need such thing in postgresql, because users of my application c=
an execute custom query and then select the aggregate function to be applie=
d to the selected columns. This can be done using Pivot Table/Chart in MS A=
ccess, but it is not sufficient, rather it will be better if postgres has s=
upport for this.


Thanks and regards to all,

CPK

>On Mon, Aug 23, 2010 at 4:56 AM, Pavel Stehule < ef=3D"mailto:pavel.stehule@gmail.com">pavel.stehule@gmail.co m> > wrote:

r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hello



2010/8/22 c k <shreeseva=
..learning@gmail.com
>:

> Hi all,

> As I am using MS Access for a long time, many tools like ms access pro=
vides

> a way to get the list of columns from a query. (using filed list in co=
mbo

> boxes in ms access). But is it possible to get such list of columns fr=
om a

> query where it is not known to the user, that which columns are define=
d in

> the base 'SELECT' statement? How? I dynamically created SQL st=
atements many

> times this situation occurs where the columns are not fixed and we hav=
e to

> get the list of columns from such a query.

> Thanks in advance.

>



Yes, it is possible, you can get a description of prepared stat=
ement's

result. See: PQprepare, PQdescribePrepared, PQdescribePortal. These

functions are in client postgresql library -

IBPQ-EXEC-MAIN" target=3D"_blank">http://www.postgresql.org/docs/8.4/intera=
ctive/libpq-exec.html#LIBPQ-EXEC-MAIN




Regards



Pavel Stehule



> CPK

>




--0015175cb71c355a17048e791041--

Re: [GENERAL] getting list of columns from a query

am 23.08.2010 10:23:12 von Scott Marlowe

Isn't this provided in odbc by myQuery.columns? Is that not
accessible to MSAccess??

On Mon, Aug 23, 2010 at 2:02 AM, c k wrote:
> I am using PostgreSQL 8.4 on Fedora Linux 13 and using MS Access as the
> front end for our application. It is not the problem associated with MS
> Access. I got the some entries while searching for the said topic that
> Oracle provides such facility.
> DESCRIBE SELECT LIST which gives the details about the column names and data
> types. I need such thing in postgresql, because users of my application can
> execute custom query and then select the aggregate function to be applied to
> the selected columns. This can be done using Pivot Table/Chart in MS Access,
> but it is not sufficient, rather it will be better if postgres has support
> for this.
>
> Thanks and regards to all,
>
> CPK
>
> On Mon, Aug 23, 2010 at 4:56 AM, Pavel Stehule
> wrote:
>>
>> Hello
>>
>> 2010/8/22 c k :
>> > 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.ht ml#LIBPQ-EXEC-MAIN
>>
>> Regards
>>
>> Pavel Stehule
>>
>> > CPK
>> >
>
>



--
To understand recursion, one must first understand recursion.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin