Re: Hiding table structure information

>
> > Would there be a way to set up the 2 databases - one with the tables and
> > data and the other that connects to the first with views into the second
> > database?
> >
> > Actually I am interested because I will soon need to set up a way to
> feed
> > data to multiple databases and would love to have a stored procedure or
> > trigger that, when the data is updated in one database, the changes are
> > propagated to all the other databases.
>
> There is a contrib package dblink that will do at least some of what you
> want.

I will look into dblink. Thanks!

You might also see if just separating stuff into different schemas will
> be good enough for you. That would allow you to have separate name spaces
> but still be able to reference tables in other schemas efficiently.
>

Actually most of the updates will be in the same database but different
schemas as you suggest. Unfortunately, due to client requirements, not
everything will be structured that way. I may have some other options
though...