Hey, nice tool! I only have sql based access to an ASE db, so I was happy to find this very well documented and nice tool to help explore the database. Since it has a different structure to postgres etc I needed a different export script, so I wanted to contribute my version if anybody else needs it. It's maybe a bit too niche to put it into the readme, so I'll leave it here for future readers or at your disposal to add it to the right place. It is mostly based on this SO answer . Unfortunately, the types have ids that don't seem to be unique across the database, so the join from this other SO post gives multiple options. I haven't figured out yet how to identify the correct one, so my script returns just the numeric type value.
SELECT'public'as table_schema, so.nameas table_name, sc.nameas column_name, sc.typeas data_type, sc.colidas ordinal_position
FROM syscolumns sc
INNER JOIN sysobjects so ONsc.id=so.idWHEREso.type='U'
Hey, nice tool! I only have sql based access to an ASE db, so I was happy to find this very well documented and nice tool to help explore the database. Since it has a different structure to postgres etc I needed a different export script, so I wanted to contribute my version if anybody else needs it. It's maybe a bit too niche to put it into the readme, so I'll leave it here for future readers or at your disposal to add it to the right place. It is mostly based on this SO answer . Unfortunately, the types have ids that don't seem to be unique across the database, so the join from this other SO post gives multiple options. I haven't figured out yet how to identify the correct one, so my script returns just the numeric type value.