Detect column type?


#1

Using column_names I can get a nice list of columns in a table, but is
there any way to detect the column type? Like “string”, “integer”,
“boolean”, etc?


#2

On 10 Jan 2009, at 17:11, Taylor S.
<removed_email_address@domain.invalid

wrote:

Using column_names I can get a nice list of columns in a table, but is
there any way to detect the column type? Like “string”, “integer”,
“boolean”, etc?

The columns method returns an array of column objects, which among
other things, has the name and type of the corresponding column.

Fred


#3

Frederick C. wrote:

On 10 Jan 2009, at 17:11, Taylor S.
<removed_email_address@domain.invalid

wrote:

Using column_names I can get a nice list of columns in a table, but is
there any way to detect the column type? Like “string”, “integer”,
“boolean”, etc?

The columns method returns an array of column objects, which among
other things, has the name and type of the corresponding column.

Fred

Indeed. It returns the below for an id column. Thanks.

#<ActiveRecord::ConnectionAdapters::SQLiteColumn:0x23736b8
@precision=nil, @primary=true, @default=nil, @limit=nil, @type=:integer,
@null=false, @name=“id”, @scale=nil, @sql_type=“INTEGER”>