Get column list from Postgres Query

[PANAGIOTIS GERMANIS <pgermanis@xxxxxxxxx>]

I want to get the names, the type and the length of all columns in a postgres query using c-api calls.

For example from: 

SELECT customers.id, customers.name, transaction.date, transaction.amount FROM customers, transactions

I must get:

customers.id, 

customers.name, 

transaction.date, 

transaction.amount 

How can I  achieve this??

Thanks in advance

___________________________________

Panos Germanis

Software Engineer

pgermanis@xxxxxxxxx

mob: 6944339998

"Peace cannot be kept by force. It can only be achieved by understanding."

(Albert Einstein)

<<attachment: smime.p7s>>