Auf Thema antworten

Hier ein Beispiel:

Tabelle erstellen:

[code]

create table auto_filled(id integer, filled text);

[/code]

Trigger-Procedure erstellen:

[code]

create function auto_filled() returns trigger as $$ begin

new.filled = 'Alberto';

return new;

end;

$$ language plpgsql;

[/code]

Trigger erstellen:

[code]

create trigger auto_filled before insert on auto_filled for each row execute procedure auto_filled();

[/code]

Datensatz einfügen:

[code]

insert into auto_filled(id) values (1);

[/code]

Datensatz abrufen:

[code]

select * from auto_filled;

[/code]

Ergebnis:

[code]

 id | filled

----+---------

  1 | Alberto

(1 Zeile)

[/code]