> produces a result like this:
>
> schema | object
> --------+--------
> public | abc
> foo | abc
> foo | xyz
> bar | xyz
> (4 rows)
>
> How can I restrict the query to the schemas in the
> current search path, i.e. the schema names returned
> by SELECT current_schemas() ?
Now, if we had functions-returning-sets, this would all be easy as all you'd
need to do would be to join it with the function returning the set of
schemas in your search path :)
Chris