thanks! I actually came to a similar solution after Roman's post. Thanks all for the replies! > Dan <ml@xxxxxxxxx> schrieb: > >> Hey, >> >> I am running PostgreSQL 8.1.4 and I want to create a user from inside a >> function. Is this possible in 8.1? >> >> Ive found quite a few references on google using EXECUTE, but this seems >> relevant to earlier versions, not 8.1. >> >> I have a function like this: >> >> CREATE FUNCTION user_create (un varchar, uid bigint, pw varchar) RETURNS >> VARCHAR LANGUAGE plpgsql AS ' >> BEGIN >> EXECUTE "CREATE USER " || un || " WITH PASSWORD " || pw; >> >> RETURN un; >> END >> '; > > This works: > > > CREATE or replace function user_create (un varchar, uid bigint, pw > varchar) RETURNS VARCHAR AS $$ > BEGIN > EXECUTE 'create user ' || un || ' with password ' || > quote_literal(pw); > return $1; > end; > $$ language plpgsql; > > > Andreas > -- > Really, I'm not out to destroy Microsoft. That will just be a completely > unintentional side effect. (Linus Torvalds) > "If I was god, I would recompile penguin with --enable-fly." (unknow) > Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >
