Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • C csvkit
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 61
    • Issues 61
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 4
    • Merge requests 4
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Package Registry
    • Infrastructure Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • wireservice
  • csvkit
  • Merge requests
  • !138

loosey option for csvsql

  • Review changes

  • Download
  • Email patches
  • Plain diff
Merged Administrator requested to merge github/fork/thejefflarson/master into master Jan 09, 2012
  • Overview 1
  • Commits 2
  • Pipelines 0
  • Changes 3

Created by: thejefflarson

I've added a --loosey option to csvsql to optionally remove the column constraints.

This is particularly useful for very large csv dumps, where type-hinting can take an extraordinary amount of time. It allows the user to generate the sql with a subset of data like so:

$ head -n 100 some-large-csv.csv | csvsql --loosey --table some-large-csv

We've run into this problem many times with datasets on the order of hundreds of thousands of rows and many columns and having something like this would save time in tweaking the schema after the fact.

Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: github/fork/thejefflarson/master