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