Views...

On Sun, 25 Mar 2001, Christian Marschalek wrote:

I can't find the desciption of "views" in the PostgreSQL docs.
Could somebody please point me out or explain database views to me?

http://www.postgresql.org/users-lounge/docs/7.0/user/sql-createview.htm

This is a good start to see how they are used in PostgreSQL.

Briefly, a view is a 'virtual' table -- you create a view with a select
statement that can relate data between different tables or use a subset of
data from a specific table. You can think of them as a 'saved query'.
Once you create a view, you can then query them just like a normal table.
You cannot, as of yet, update views in PostgreSQL, they are read only.

-- Brett
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
As the poet said, "Only God can make a tree" -- probably because it's
so hard to figure out how to get the bark on.
-- Woody Allen

"Brett W. McCoy" wrote:

Briefly, a view is a 'virtual' table -- you create a view with a select
statement that can relate data between different tables or use a subset of
data from a specific table. You can think of them as a 'saved query'.
Once you create a view, you can then query them just like a normal table.
You cannot, as of yet, update views in PostgreSQL, they are read only.

Not by default, but you can of course define your own rules to allow updating.

- Richard Huxton

Well I think I can do it without updating...

Thanks to both of you :o)