From: | "pblunat" <pblunat(at)ujf-grenoble(dot)fr> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | : Execute a string of command in sql'script |
Date: | 2001-01-29 12:30:13 |
Message-ID: | 953nlp$28rc$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 ;)-
From | Date | Subject | |
---|---|---|---|
Next Message | ender | 2001-01-29 12:44:54 | converting oracle raw longs |
Previous Message | Evelio Martinez | 2001-01-29 12:11:47 | Problems with authentication and some questions |