Re: [ADMIN] Hiding table structure information

2006-06-27 Thread Jim Nasby
On Jun 26, 2006, at 7:48 PM, Aaron Bono wrote: 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? google: postgresql dblink Actually I am interested because I will soon need to set up a

Re: [ADMIN] Hiding table structure information

2006-06-27 Thread Aaron Bono
> 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 pr

Re: [ADMIN] Hiding table structure information

2006-06-27 Thread Bruno Wolff III
On Mon, Jun 26, 2006 at 19:48:32 -0500, Aaron Bono <[EMAIL PROTECTED]> wrote: > 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

Re: [ADMIN] Hiding table structure information

2006-06-26 Thread Aaron Bono
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 o

Re: [ADMIN] Hiding table structure information

2006-06-26 Thread Jonah H. Harris
On 6/26/06, Carlos H. Reimer <[EMAIL PROTECTED]> wrote: Maybe the question should be reformulted to: is there a way to hide pg_catalog schema? I think it can?t not be done because all metadata are there, but maybe somebody can see a solution. You could use a set returning function and a view to