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
>
> ************
