| From: | Jacob Coby <jcoby(at)listingbook(dot)com> |
|---|---|
| To: | Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr> |
| Cc: | Dan Strömberg <dan(dot)stromberg(at)stockholm(dot)bonet(dot)se>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Column info without executing query |
| Date: | 2006-07-21 13:02:10 |
| Message-ID: | 44C0D052.2090405@listingbook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Volkan YAZICI wrote:
> On Jul 20 08:21, Dan Strömberg wrote:
>> I would like to know if it is possible to find out the datatypes in the
>> resultset of a query or a set returning
>> function without actually executing them ?
>
> As Tom mentioned, there's support for this feature in the protocol
> level, but I don't know any API supports this yet. However, here's a
> patch that adds Describe functionality for Prepared Statements and
> Cursors to libpq:
> http://archives.postgresql.org/pgsql-hackers/2006-06/msg01281.php
PHP supports it with the pg_field_type() function.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volkan YAZICI | 2006-07-21 13:14:52 | Re: Column info without executing query |
| Previous Message | AL ELK | 2006-07-21 12:37:44 | PGSQL 8.1.4 on Win2003 at istanbul :), could not access status of transaction xxxxx , could not open file "pg_subtrans/000A": Invalid argument |