Postgres Pro
Downloads
Home   >   mailing lists

Are views created 'on the fly' - Mailing list pgsql-novice

From richard terry
Subject Are views created 'on the fly'
Date
Msg-id 200907051020.06485.rterry@pacific.net.au
Whole thread Raw
Responses Re: Are views created 'on the fly'  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-novice
Tree view 
I had an occasion to generate a unique key on a complex view and noticed that
every time I opened the view in pgAdmin, that the start key changes, does
that mean that every time one references a view it is created 'on the fly',
before you query it for data?

regards

Richard

pgsql-novice by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres
Next
From: Andreas Kretschmer
Date:
Subject: Re: Are views created 'on the fly'