On Thursday, November 04, 2010 15:03:49 Scott Marlowe wrote: > On Thu, Nov 4, 2010 at 12:43 PM, Terry Lee Tucker <te...@chosen-ones.org> wrote: > > Greetings: > > > > Lately, I've begun using views quite often especially when queries for > > various reports, etc. become complicated. I am now wondering if there is > > a price to pay in terms of overhead for this. In truth, I don't really > > understand how a view works. I know that it takes on many of the > > attributes of a table, but is it a table? Is the data pulled together > > when one selects from the view or is it maintained as a table all along. > > Guidance to the ignorant appreciated... > > In pgsql a view is actually a rule that fires off the original query > for you. So it's a simple wrapper, and is the same, for the most > part, as simply typing in the original query again. So, it's pretty > simple, and there's no real overhead to worry about.
Thank you Scott! This is exactly what I needed to know... -- Terry Lee Tucker tel: (336) 372-5432; cell: (336) 404-6897 te...@chosen-ones.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
