Ooops, so easy using escape. Sorry.
select csvwrite('C:\temp\test.txt', 'select * from v1', 'charset=UTF-8
fieldDelimiter= escape= writeColumnHeader=false') as "written";Enter code
here...
On Wednesday, June 8, 2016 at 4:45:36 PM UTC+2, t603 wrote:
>
> Hello,
>
> I have a quite simple question about CSVWRITE in H2 1.4.191. My code is:
>
> create or replace view v1 as select '"a"';
> select * from v1;
> select csvwrite('C:\temp\test.txt', 'select * from v1', 'charset=UTF-8
> fieldDelimiter= writeColumnHeader=false') as "written";
>
> And I got:
>
> ""a""
>
> But I want to get:
>
> "a"
>
> How can I specify fieldDelimiter to get my requested output?
>
> Thank You in advance for Your answer. Stepan
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
