RE: : Execute a string of command in sql'script
От | Henshall, Stuart - WCP |
---|---|
Тема | RE: : Execute a string of command in sql'script |
Дата | |
Msg-id | E2870D8CE1CCD311BAF50008C71EDE8E017CB197@MAIL_EXCHANGE обсуждение исходный текст |
Ответ на | : Execute a string of command in sql'script ("pblunat" <pblunat@ujf-grenoble.fr>) |
Список | pgsql-general |
Could you execute aa system command (perhaps in a c function using system) to pass this command to psql. (maybe write it to a file first then redirect stdin, or perhaps pipe an echo command if using shell to exec psql.) (ok so theres got to be a better way, but it might work :) ) - Stuart > -----Original Message----- > From: pblunat [SMTP:pblunat@ujf-grenoble.fr] > Sent: Monday, January 29, 2001 12:30 PM > To: pgsql-general@postgresql.org > Subject: : Execute a string of command in sql'script > > Hi all, > I am so sorry but problem below is very urgent for me now!!! > If isn't possible to do, i must take another way of developpement for my > data base. > > I'm using PostgreSQL 7.0.2 on RedHat 6.0. > > I compose a SQL command string with function below : > > > CREATE FUNCTION bdrm_copy(text, text) RETURNS text AS ' > > DECLARE > baseact ALIAS FOR $1; > namefich ALIAS FOR $2; > path0 TEXT; > path1 TEXT; > path2 TEXT; > path3 TEXT; > BEGIN > SELECT INTO path0 CAST(ig_tempo AS TEXT) > FROM ti_bdrm > WHERE ig_base = baseact; > path0 := trim(path0) || trim(namefich); > path1 := ''COPY ttx_window7 TO \'\'''; > path2 := path1 || path0; > path3 := ''\'\'''; > path0 := path2 || path3 || '';''; > RETURN path0 ; > END;' > LANGUAGE 'plpgsql'; > > > the result of : > > SELECT bdrm_copy('MOHO99', 'test2.txt') AS my_command_string; > > is : > > my_command_string > ----------------------------------------------- > COPY ttx_window7 TO '/db/bdrm/out/test2.txt'; > > > Is it possible to execute this line of command? More generally, can one > execute the contents of a variable or a field in postgresql' script? > > Thanks ;)- > > > >
В списке pgsql-general по дате отправления: