Teddy Limousin <mongaru007(at)gmail(dot)com> writes:
> I guess this is because when executing the sql command to install lo, it
> makes it visible from the public schema only
> not from the schema I`m using. So my question is how can I make lo type to
> be visible from all schemas
> by visible I mean accesible: not need to use for example public.lo to define
> a field of type lo
It sounds like you removed the public schema from your search_path
setting. Don't do that ...
regards, tom lane