Loading file into a DB

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
rakgol_a
Posts: 13
Joined: Wed 17 Oct 2007 13:10

Loading file into a DB

Post by rakgol_a » Wed 22 Apr 2009 15:46

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

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 23 Apr 2009 08:23

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.

Post Reply