using schemas to create a virtual DB?

[Bob Parkinson]

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?

Cheers,

Bob
This message has been scanned but we cannot guarantee that it and any
attachments are free from viruses or other damaging content: you are
advised to perform your own checks. Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Shridhar Daithankar]

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly