Re: [GENERAL] what is "view?"

2000-01-26 Thread Peter Eisentraut
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 rule

Re: [GENERAL] what is "view?"

2000-01-26 Thread Jose Soares
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 lis