Philipp Kraus writes:
> Can I create a view, that can be used like a table, so on insert statements
> the default values are set?
Sure. Just use ALTER VIEW SET DEFAULT to attach default values to the
columns of the view.
regards, tom lane
--
Sent via pgsql-general ma
Hello,
I use some views for creating some different accessibility of the table data.
For inserting I use a rule, which works at the moment, but
my rules runs the SQL statement "insert into myschema.mytable values (new.*)"
If I run on my view the command: insert into myview (field1, field4) value