Re: Schemas: status report, call for developers - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Schemas: status report, call for developers
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEFPCCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Schemas: status report, call for developers  (Ian Barwick <barwick@gmx.net>)
List pgsql-hackers
> 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



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Schemas: status report, call for developers
Next
From: Tom Lane
Date:
Subject: Re: Schemas: status report, call for developers