Forum OpenACS Q&A: Re: Running the psql COPY command from db_dml

Error in include template "/var/www/openacs/packages/openacs-bootstrap3-theme/resources/templates/packages/forums/lib/search/search-form": can't read "form:id": no such variable
Collapse
13: Re: Running the psql COPY command from db_dml (response to 1)
Posted by Guan Yang on 04/22/05 01:27 PM
Nis: That's right, but you can't run psql commands in db_dml. You'd have to write out a temporary SQL script and invoke exec psql.
Collapse
16: Re: Re: Running the psql COPY command from db_dml (response to 13)
Posted by Konstantinos Kokkorogiannis on 04/25/05 05:31 PM
in order to do that I did the following:

Old way:

db_dml import_to_db " copy ml_import_records ( record ) from :temp_filename"

the new way:
exec "$psqlpath/psql -h $host -p $port -U $user $dbname < /tmp/$file_with_sql"

Where "$file_with_sql" contains actually the following

\copy ml_import_records ( record ) from 'temp_file_name'

The First one works fine, but the second doesnt. It seems that no matter what I do, only commands like [db_dml] or [file copy] can "see" the file I am uploading (using ad_form).
Even if I try to do an "exec cp temp_file_name new_file" I get the same error:
"no such file or directory"