On Fri, Aug 7, 2009 at 9:52 AM, Adrian Klaver <akla...@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
