Subject Re: [firebird-support] Export data to CSV file from stored procedure?
Author Tim Ward
You want to be looking around your external CSV file being an "external table" - that's the only way to write to files from stored procedures AFAIK, so, no matter how convoluted the code ends up, that's probably the approach you'll have to take.

(Unless there's new stuff in 2.5 I don't know about, I've only done this with 2.1.)

On 20/08/2014 17:19, conversar@... [firebird-support] wrote:

Hi there,

As subject, is it possible to export a query result set to an external csv file from a Firebird stored procedure? I know this can be done with IBExpert but we are looking for a pure firebird sql solution. We are using Firebrd 2.5.

Any pointers on how to do this will be much appreciated.



Tim Ward