Horton

Re: 7.3 Prepared statements

Francisco J Reyes <fran@natserv.net>

View thread View on postgr.es
From: Francisco J Reyes <fran@natserv.net>
To: Neil Conway <neilc@samurai.com>
Cc: Ericson Smith <eric@did-it.com>, Postgresql General <pgsql-general@postgresql.org>
Date: 2002-12-26T17:34:04Z
Lists: pgsql-general 
On 17 Dec 2002, Neil Conway wrote:

> On Tue, 2002-12-17 at 10:19, Ericson Smith wrote:
> > 1. What is the lifetime of the plan created?
>
> >From the PREPARE reference page:
>
> Prepared queries are stored locally (in the current backend), and only
> exist for the duration of the current database session.

What is the difference/advantage between a prepared query and a view?