types in postgres are schema bound. There is no knowing where the geography type is in your database. You might want to check all the schema to find where the type is, its in public by default unless you renamed public, and add it to the search path. Also, If you have some sort of multi tenancy system, you might want to use "$user" in the search path. So that other users don't have to prefix their queries.
