clojurekormasqlkorma

How to access tables in other schema in korma?

In SQL, accessing tables in other schema is simple:

select * 
from other_schema.t
where ...

How can I do this in korma? What I actually to do is to access information_schema.tables table. So defining another db by defdb wouldn't be helpful.

I've tried to define the entity, however, failed.

(defentity information_schema.tables)
Solution

  • I've got to know that there is a way to specify the base table when defining an entity. When specifying the base table, it allows to set the schema with ..

    (defentity tables
  (table :information_schema.tables))

    This works fine for accessing information_schema.tables table, without defining another db.