Generate DDL SQL create table statement after scanning CSV file

Question

Are there any command line tools (Linux, Mac, and/or Windows) that I could use to scan a delimited file and output a DDL create table statement with the data type determined for me?

Did some googling, but couldn't find anything. Was wondering if others might know, thanks!

score 5 · Accepted Answer · answered Oct 10 '14 at 19:27

DDL-generator can do this. It can generate DDL's for YAML, JSON, CSV, Pickle and HTML (although I don't know how the last one works). I just tried it on some data exported from Salesforce and it worked pretty well. Note you need to use it with Python 3, I could not get it to work with Python 2.7.

Shanu M · Answer 2 · 2020-03-04T07:46:12.173

1

You can also try https://github.com/mshanu/idli. It can take csv file as input and can generate create statement with appropriate types.It can generate for mysql, oracle and postgres. I am actively working on this and happy to receive feedback for future improvement

edited Mar 04 '20 at 07:46

answered Mar 03 '20 at 05:15

Shanu M

11
2

1

Would it be better to put in more explanation? – cctan Mar 03 '20 at 05:47

score 0 · Answer 3 · edited Jul 06 '23 at 21:37

0

Recently I tried this online tool convertcsv.com/csv-to-sql. I did some adjustments but it helped me a lot!

edited Jul 06 '23 at 21:37

S.B

13,077
10
22
49

answered Jun 28 '23 at 21:23

maihe

43
8

Generate DDL SQL create table statement after scanning CSV file

3 Answers3