Thread: Datatype of a column

Datatype of a column

From
Ishaya Bhatt
Date:
Hi,
      Is it possible to identify the datatype of the column of a sort query ?

Regards,
Ishaya

Re: Datatype of a column

From
Kevin Grittner
Date:
Ishaya Bhatt <ishayabhatt@gmail.com> wrote:

> Is it possible to identify the datatype of the column of a sort
> query ?

Does the pg_typeof() function do what you want?  If not, could you
give more context?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: Datatype of a column

From
Ishaya Bhatt
Date:
Is there any way of calling the PSQLexec() and PQftype() methods from the backend?


On Thu, Nov 7, 2013 at 2:20 PM, Kevin Grittner <kgrittn@ymail.com> wrote:
Ishaya Bhatt <ishayabhatt@gmail.com> wrote:

> Is it possible to identify the datatype of the column of a sort
> query ?

Does the pg_typeof() function do what you want?  If not, could you
give more context?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Re: Datatype of a column

From
Luca Ferrari
Date:
On Sat, Nov 9, 2013 at 3:53 PM, Ishaya Bhatt <ishayabhatt@gmail.com> wrote:
> Is there any way of calling the PSQLexec() and PQftype() methods from the
> backend?

What is the purpose? If I get it right, the above functions are used
to communicate with the backend, therefore I see a kind of
"communication looping" here.

Luca