Re: Getting result set metadata without executing query? - Mailing list pgsql-novice

Marc Ramirez <mrami@mrami.homeunix.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.

            regards, tom lane