From: | Marc Ramirez <mrami(at)mrami(dot)homeunix(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Getting result set metadata without executing query? |
Date: | 2002-07-10 14:06:22 |
Message-ID: | 20020710095913.A8856-100000@mrami.homeunix.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, 10 Jul 2002, Tom Lane wrote:
> Marc Ramirez <mrami(at)mrami(dot)homeunix(dot)org> writes:
> > Is this possible with PostgreSQL?
>
> SELECT * FROM foo LIMIT 0
>
> works in recent releases, though I think not before 7.1 or so.
>
> You'd want to avoid anything that involves a SORT step, though,
> since it's not truly "not executing the query", just abandoning
> it as soon as the first output row has been generated internally.
Okay. That's cool. The reason I ask is that I have this little utility
for Sybase where you give it a query and it generates a C++ class with
getters named for the columns, yadda yadda.
Maybe if I get ambitious, I might think about adding the functionality. :)
Thanks alot,
Marc.
--
I telnetted to whitehouse.gov,
and all I got was this lousy .signature!
From | Date | Subject | |
---|---|---|---|
Next Message | Leandro Fanzone | 2002-07-10 15:03:36 | Translate problems |
Previous Message | Pam Wampler | 2002-07-10 13:55:22 | Re: oid2name |