From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Dario Teixeira <darioteixeira(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Information about columns |
Date: | 2009-06-22 12:52:18 |
Message-ID: | 162867790906220552m3821fc6ao2cd70381aaeb1faf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2009/6/22 Dario Teixeira <darioteixeira(at)yahoo(dot)com>:
>
> Hi,
>
> Is there some way to find out meta-information about the columns generated
> by any SELECT query? If the SELECT returns values from a regular table or
> a view, I can use pg_class and pg_attribute to get the info I need:
>
> CREATE TABLE foobar (quant int);
> SELECT quant FROM foobar;
> SELECT attname, attnum FROM pg_attribute, pg_class WHERE attrelid=pg_class.oid AND relname='foobar';
>
> But what if the columns belong to a "virtual" table instead, as per the
> (silly) example below?
>
> SELECT 1, 2*quant FROM foobar;
>
you can do it on low level - look on functions
PQdescribePrepared
PQdescribePortal
regards
Pavel Stehule
> Thanks in advance for any help you might give me!
> Best regards,
> Dario Teixeira
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | William Temperley | 2009-06-22 12:54:57 | Killing a data modifying transaction |
Previous Message | Craig Ringer | 2009-06-22 12:43:09 | Re: Information about columns |