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.
regards, tom lane