Postgres Pro
Downloads
Home   >   mailing lists

Get column list from Postgres Query - Mailing list pgsql-general

From PANAGIOTIS GERMANIS
Subject Get column list from Postgres Query
Date
Msg-id 595BC672-8542-4233-8BDA-17C6DC6F679F@gmail.com
Whole thread Raw
Responses Re: Get column list from Postgres Query
List pgsql-general
Tree view
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, 
transaction.date, 
transaction.amount 

How can I  achieve this??

Thanks in advance

___________________________________
Panos Germanis
Software Engineer
mob: 6944339998

"Peace cannot be kept by force. It can only be achieved by understanding."
(Albert Einstein)

Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Schema Archive cant find table
Next
From: Scott Ribe
Date:
Subject: Re: Get column list from Postgres Query