SQL create table types

#1

I can’t get my import from create table to spit out the right datatypes. How do you make it put in a varchar?

#2

Can share the create table SQL? Mockaroo should choose Custom List for all varchar fields. The library that Mockaroo uses specifically handles the postgres dialect. Your mileage may vary with other dialects.

#3

Won’t be able to get the actual code until I get to work tomorrow, but I have tried pretty much every variation of:

/(varchar2?|varying)(\(\d+(\s+BYTE)?\))?|string|text/

(I didn’t want to write out all the combinations. You know regex right?:wink:)
The only times it actually reads at all it things I am asking for a custom list. I can manually change it later but I would like to know how it is meant to work.