Thread: what is "view?"
When listing my tables and indices in psql, I see a "view?" in type. What is this type? Where can I read about it in the manual? The table listed as "view?" use to be listed as "table" but suddently changed when I added rules. Do rules make a table a view? Marc
A view is a table with a rule SELECT For excample if you have a table named my_table and you create a rule like: CREATE RULE "_RETmy_table" AS ON SELECT TO "my_table" DO INSTEAD SELECT * FROM your_table; In this way you your table my_table became a view. José Marc Tardif wrote: > When listing my tables and indices in psql, I see a "view?" in type. What > is this type? Where can I read about it in the manual? > > The table listed as "view?" use to be listed as "table" but suddently > changed when I added rules. Do rules make a table a view? > > Marc > > ************
On 2000-01-25, Marc Tardif mentioned: > When listing my tables and indices in psql, I see a "view?" in type. What > is this type? Where can I read about it in the manual? CREATE VIEW > > The table listed as "view?" use to be listed as "table" but suddently > changed when I added rules. Do rules make a table a view? The behaviour you observed is a bug. (But views still do exists, see above.) -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden