Teddy Limousin <mongaru007@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general