Hi, My 2 cents...
I would prefer to have the COPY as a shell command as a .copy with
options for file-format.
It is not always practical to compile/bind/execute insert statements
especailly while designing your database
and while troubleshooting.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Saturday, May 22, 2004 3:17 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Version 3 design issue: Keep the COPY command?
D. Richard Hipp ([EMAIL PROTECTED]) wrote:
> Here are the options:
> (1) Extend the syntax of the COPY command to allow the user
> to specify the text representation of the file being
> imported.
I would prefer this option. In addition it should be possible to remove the
COPY-Command by a compiletime switch. Further more it would be helpful to
have the possibility of asking in runtime whether the COPY-Command is
supported.
> (2) Always assume the import is coming from a UTF-8 file.
> (3) Remove the COPY command all together.
Hans-Jürgen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
