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
> 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
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
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
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
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes:
> Maybe the question should be reformulted to: is there a way to hide
> pg_catalog schema?
There is not. My advice would be to put clients in separate databases
if you need that much isolation between them.
regards, tom lane
; -Mensagem original-
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Em nome de Carlos H. Reimer
> Enviada em: segunda-feira, 26 de junho de 2006 14:40
> Para: pgsql-admin@postgresql.org
> Assunto: [ADMIN] Hiding table structure information
>
> Hello,
>
> Is there
Carlos H. Reimer
Enviada em: segunda-feira, 26 de junho de 2006 14:40
Para: pgsql-admin@postgresql.org
Assunto: [ADMIN] Hiding table structure information
Hello,
Is there a way to hide the table definition structure from an user, even if
the user has privileges to select data from that table?
Reimer
Hello,
Is there a way to hide the table definition structure from an user, even if
the user has privileges to select data from that table?
Reimer
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
