ekekakos <ekekakos(at)hol(dot)gr> writes:
> Thanks but how, in SQL server you put the function USER() (if I remember
> well) and it works.
> Here it does not work.
Define "does not work", please?
regression=# create domain username as text default user;
CREATE DOMAIN
regression=# create table foo(f1 int, lastupdateuser username);
CREATE TABLE
regression=# insert into foo(f1) values(42);
INSERT 0 1
regression=# select * from foo;
f1 | lastupdateuser
----+----------------
42 | postgres
(1 row)
regards, tom lane