On Friday 07 August 2009 07:27:28 am John wrote: > On Friday 07 August 2009 06:56:22 am Scott Mead wrote: > > On Fri, Aug 7, 2009 at 9:52 AM, Adrian Klaver <aklaver@xxxxxxxxxxx> 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 Sorry I figured out how it works. Thanks to all, Johnf -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
