[Users] OpenAPI and copy into

[Chris Clark]

Rolf Theisinger wrote:
> Am Mittwoch, 25. April 2007 09:31 schrieb Ronald Jeninga:
>   
>> Hi,
>>
>> What's difficult about writing contents of memory to a file? The database
>> server can't write the file for you, it might even be on another node.
>> The library doesn't seem to have the functionality implemented, so do it
>> yourself. Can't be that hard.
>>
>> Ronald
>>
>>     
>
> it is not that hard, but I only do it myself if there is no other way. Normaly 
> it is no problem to copy a table to file, so anyone who uses the
> ingres sql terminal can make a copy like this:
> "copy table myTable() into 'filename'"
>
> Before I start doing it myself, I ask!
>
> So, from my point of view it is not obvious, why this command should
> not work with OpenAPI and I ask again, if anybody >knows< that this
> won't work.
>   

I can confirm that Ronald is correct; with OpenAPI, the application is 
responsible for file IO. Depending on what you are attempting to do, the 
sql terminal may be a better solution.

Chris