Re: Extracting DB schema (newbie Q)

2012-05-17 Thread Steve Sawyer
Thanks, James, but John Gordon identified my usage error so I'm good to go now. On Mon, 14 May 2012 09:28:06 -0700 (PDT), james hedley wrote: >On Monday, 14 May 2012 17:01:49 UTC+1, Steve Sawyer wrote: >> Brand-new to Python (that's a warning, folks) >> >> Tryi

Re: Extracting DB schema (newbie Q)

2012-05-14 Thread Steve Sawyer
x27;]['size'] # -> 200 table_dict['Artist']['size'] #-> 50 Is this (nesting dictionaries) a good way to store multiple attributes associated with a single key value? On Mon, 14 May 2012 17:05:17 + (UTC), John Gordon wrote: >In Steve Sawyer > writes

Extracting DB schema (newbie Q)

2012-05-14 Thread Steve Sawyer
Brand-new to Python (that's a warning, folks) Trying to write a routine to import a CSV file into a SQL Server table. To ensure that I convert the data from the CSV appropriately, I"m executing a query that gives me the schema (data column names, data types and sizes) from the target table. What