>> DB = Sequel('postgres://postgres:postgres@localhost/reality_development') >> schema = DB.schema >> schema.class => Sequel::InformationSchema >> schema.database == DB => true >> schema.tables # (table_schema = :public) # t = DB[:"INFORMATION_SCHEMA.TABLES"].filter(:table_schema => 'public') => [:nodes, ...] >> schema.tables(:information_schema) # specify table_schema => [:triggers, :tables, ...] >> schema.columns(:nodes) # (table_name, table_schema = :public) # t = DB[:"INFORMATION_SCHEMA.COLUMNS"].filter(:table_schema => 'public', :table_name => 'nodes') => [{:name => :id, :type => :integer, :unique => true, ...}, ...blahblah] # column info: :name => :blah :type => :blah :null => true|false :default => blah