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 ;)-
>
>
>
>