Page 1 of 1

Loading file into a DB

Posted: Wed 22 Apr 2009 15:46
by rakgol_a
Hi,

Is there way of loading data into bytea column via a
stored procedure, or the PgLoader the only way
where row must exist first??

Thanks,
Alfred

Posted: Thu 23 Apr 2009 08:23
by Plash
If you load one row, you don't need TPgLoader.
You can execute INSERT or UPDATE statement using TPgQuery, or create a stored procedure with such statement, and call it using PgDAC.

You can load data from a file to the parameter value using the LoadFromFile method of TDAParam.