Re: using schemas to create a virtual DB?

From: Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net>
To: "Bob Parkinson" <rwp(at)biome(dot)ac(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: using schemas to create a virtual DB?
Date: 2004-09-20 08:51:50
Message-ID: 200409201421.50348.shridhar@frodo.hserus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday 20 Sep 2004 1:58 pm, Bob Parkinson wrote:
> Hi,
>
> I need to give some partners to a read only subset of my data. I'm
> currently looking at schemas, not something I've looked at or used before.
>
> Can I use schemas to create a virtual DB (built by views) onto my main DB?
> Or is this a dead end thought?

You should look at views. Of course placing all related views in single schema
is a good idea..

HTH

Shridhar

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karel Zak 2004-09-20 09:20:34 Re: Problem in converting int to timestamp value - why?
Previous Message Bob Parkinson 2004-09-20 08:28:10 using schemas to create a virtual DB?