On Thursday, November 29, 2012 11:27:06 AM UTC-8, Davy Campano wrote: > > Is it possible to select from a table in a different database on the same > host using the short syntax similar to this: > > DB[:"database_name.users"].limit(1).all > > I'm sure if so it's probably easy, but I cannot figure out what the syntax > is, or if it's even possible. Thanks in advance! >
You just need to use a qualified identifier, so: DB[:database_name__users].limit(1).all This is covered in the README and various other parts of the documentation, though usually it refers to tables qualifying columns instead of schemas qualifying tables (since that is the more common case). Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/eK2yQnnjYgoJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
