| From: | Dennis Gearon <gearond(at)cvc(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | views and multiple tables? |
| Date: | 2003-02-28 14:51:45 |
| Message-ID: | 3E5F7781.BD8BB17@cvc.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
The manual mentions:
"CREATE VIEW will define a view of a table. The view is not physically
materialized. Instead, a query
rewrite retrieve rule is automatically generated to support retrieve
operations on views."
It says nothing about whether that select statement can access MULTIPLE
tables, which I think would be one of the best benefits of a view, an
'unnormalized view' of some data, to work on data sets, not tables.
So can views be created with a select statement which selects from
multiple tables?
--
Carpe Dancem ;-)
-----------------------------------------------------------------
Remember your friends while they are alive
-----------------------------------------------------------------
Sincerely, Dennis Gearon
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Bartlett | 2003-02-28 14:52:22 | Re: Few Simple Questions |
| Previous Message | Jan Gravgaard | 2003-02-28 11:36:40 | Warning: Supplied argument is not a valid PostgreSQL link resource |