Re: [GENERAL] what is view?
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
Re: [GENERAL] what is view?
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 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden