Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12879

Please add support for exporting column headers to CSV

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      select .. into outfile works great, but there doesn't seem to be a way to include column headers. Some creative workarounds have been proposed on SO (https://stackoverflow.com/questions/5941809/include-headers-when-using-select-into-outfile) but nothing convenient.

      In postgres, as you probably know, export is done with the copy command. Here are their docs (https://www.postgresql.org/docs/current/static/sql-copy.html) though I'm not sure how useful they are to us here.

      I wanted this to have Issue Type = New Feature, but the only option Jira gave me was "Bug". Please feel free to change any of that metadata as you see fit.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jared Jared Beck
              Votes:
              4 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.