Jeff wrote:
>
> Could someone please tell me how I might determine the column type (char
> vs. integer is good enough) if I know the column name?

I don't see the column name to have any real link to what type of column it
is. But if you are to create a table, and not sure what type to use, then you
have to think of what you want to store, has it to be something that a human
must be able to determine what the data means when looking on that one table
or not.
Text based searches do take longer time than numeric (int/float), while
numeric values always takes the full size, text based many times just takes
the length of the string.

I would avoid to use text based ID columns.


--

//Aho