Finding column names using DBI

A useful snippet, should you ever require to get the column names of a table that you are connecting through DBI:

DBI.connect(something’) do |con|
  con.execute(“SELECT * FROM FOO”).each do |row|
    p row.inspect
    p row.column_names
  end
end

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s