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

Please add support for exporting column headers to CSV

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      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

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jared Jared Beck
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: