Menu

#5 --csv-format option doesn't work

2.0
closed
None
2019-12-30
2019-08-17
No

I tried to modify output format with option "-f" but I see always the same result. I tried "-f EXCEL", "-f MYSQL", "-f TDF" and "-f RFC-4180" but I canot see any difference in the output format.

Example:

user@test~$ java -jar jdbcsql.zip -m postgresql -h localhost -d rdb -U dbuser -P "secret" -f EXCEL -s "," "select count(*) as count1,count(*) as count2 from pg_settings;"

BTW, this command reports the error that column count is there twice. This is not a problem for other tools (like jisql).

user@test~$ java -jar jdbcsql.zip -m postgresql -h localhost -d rdb -U dbuser -P "secret" "select count(*), count(*) from pg_settings;"
The header contains a duplicate entry: 'count' in [count, count]

When I disable headers with option "-H", error is not reported:

user@test~$ java -jar jdbcsql.zip -m postgresql -h localhost -d rdb -U dbuser -P "secret" -H "select count(*), count(*) from pg_settings;"

Discussion

  • Atanas Dichev

    Atanas Dichev - 2019-08-17
    • status: open --> pending
     
  • Atanas Dichev

    Atanas Dichev - 2019-08-17
    • status: pending --> accepted
    • assigned_to: Atanas Dichev
     
  • Atanas Dichev

    Atanas Dichev - 2019-12-30
    • status: accepted --> closed
     
  • Atanas Dichev

    Atanas Dichev - 2019-12-30
    • Milestone: 1.0 --> 2.0
     

Log in to post a comment.

MongoDB Logo MongoDB