Re: [GENERAL] view with insert rule

2012-12-30 Thread Tom Lane
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

[GENERAL] view with insert rule

2012-12-30 Thread Philipp Kraus
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