Re: [GENERAL] How to use slash commands in a function

2007-02-15 Thread Alvaro Herrera
vanessa escribió: > > Hi guys, > > I was wondering how could i (if at all possible) to use say a command like: > > \! touch fred.txt in a function? > i.e. > > CREATE FUNCTION myfunc() RETURNS TRIGGER AS > 'BEGIN > \! touch fred.txt > RETURN NEW; > END;' > LANGUAGE 'p

[GENERAL] How to use slash commands in a function

2007-02-15 Thread vanessa
Hi guys, I was wondering how could i (if at all possible) to use say a command like: \! touch fred.txt in a function? i.e. CREATE FUNCTION myfunc() RETURNS TRIGGER AS 'BEGIN \! touch fred.txt RETURN NEW; END;' LANGUAGE 'plpgsql'; At the moment i get: ERROR: syntax er