On Friday 07 August 2009 06:56:22 am Scott Mead wrote:
> On Fri, Aug 7, 2009 at 9:52 AM, Adrian Klaver <aklaver@comcast.net> wrote:
> > On Friday 07 August 2009 6:42:07 am John wrote:
> > > Hi,
> > > There is an accounting system called postbooks that uses Postgres for
> > > the backend. I just downloaded the program yesterday. What is
> > > interesting
> >
> > is
> >
> > > within one database there are two schemas (api and public). The 'api'
> > > schema is a bunch of views. The interesting part is if you update a
> > > view in the 'api' it updates a table in the 'public' schema. Could
> > > someone explain how that works? I was not aware that within a
> > > databases that the schema's could talk to each other.
> > >
> > > I looked in the doc's (that I have) but did not find an entry that
> > > describes doing anything similar.
> > >
> > > Johnf
> >
> > From:
> > http://www.postgresql.org/docs/8.4/interactive/sql-createschema.html
> >
> > It's very simple, you can update something anywhere you have permissions:
>
> insert into api.table....
>
> insert into public.table....
>
> Or by using search_path, which works like the $PATH or %path% environment
> variables on linux or windows. It's just a search list of schemas to use.
>
> If my search path was:
> public, api
>
> and I type:
>
> create table test (id int);
>
> Then I will have a table called public.test
>
> If my search_path was:
> api, public
>
> and I type:
>
> create table test (id int);
>
> Then I will have a table called api
>
> etc...
>
> --Scott
Interesting where is the search path set? Better how is it set?
Johnf
